New Feature of 10.2g: Eliminate Control File Re-Creation
Before Oracle 10.2g if we need to change the limit of MAXLOGFILE,
MAXLOGMEMBERS, MAXLOGHISTORY, MAXDATAFILES, and MAXINSTANCES then the
possible solutions is either RE-create new controlfile or create a new
database.
But
from Oracle 10.2g all sections of the control file are now
automatically extended when they run out of space. This means that
there is no longer a requirement to re-create the control file when
changes in the configuration parameter the MAXLOGFILE, MAXLOGMEMBERS,
MAXLOGHISTORY, MAXDATAFILES, and MAXINSTANCES are needed.
Two different Sections of Control file:
--------------------------------------------
Visit
http://arjudba.blogspot.com/2008/04/new-feature-of-102g-eliminate-control.htmlhttp://arjudba.blogspot.com
__________________________________________________________
Not happy with your email address?.
Get the one you really want - millions of new email addresses available now at
Yahoo! http://uk.docs.yahoo.com/ymail/new.html
[Non-text portions of this message have been removed]
We are using:
NLS_CHARACTERSET WE8ISO8859P15,
NLS_NCHAR_CHARACTERSET UTF8
NLS_LANGUAGE AMERICAN
on 10.2.0.3.0 Oracle DB,
Does anyone know how to convert from diacritical (international)
characters to ascii in sql (view) as one of our legacy systems cannot
handle non-ascii characters?
I've tried
select name,
convert(name, 'US7ASCII', 'WE8ISO8859P15')
from UV_AD_IMAGENOW_BIODEMO
results:
SæBø,Håkon S?B?,H?kon
TIA
I would do it by writing a batch file as follows:
export.bat
-------------------------------------------------------------
time /t > exp.log
exp userid=<USERID>/<PW>@<DATABASE> file=<EXP_FILENAME>.dmp
log=exptmp.log tables=(TABLE1,TABLE2,...)
time /t >> exptmp.log
type exptmp.log >> exp.log
del exptmp.log
-------------------------------------------------------------
-Madu
--- In VOUGlist@yahoogroups.com, "wbuker" <whbuker@...> wrote:
>
> Folks,
>
> We are doing daily exports as part of our backup strategy. We are
> working in a windows environment and with Oracle 10.0.2.0.3.
>
> I would like to see a time the export started in the export log file
> and the time the export completed in the same log file.
>
> Here is what I have tried. If I create a log file using notepad, and
> on the command line say: call time /t >> cb190t3.log, it will put the
> time in there fine.
>
> Then if I run my export and tell it to put the results in the same
> log, it will overwrite what I have already entered. So I need some
> help figuring out how to put the time it started, the export log, and
> the time it finished.
>
> Thanks in advance,
>
>
> Bill Buker,
> Enterprise Database Manager
> Swansons Services
> whbuker@...
>
Echo your start and end time to a different log, then append that log to the exp
log when exp is done
-- Mark C. Stock
enQuery
----- Original Message -----
From: wbuker
To: VOUGlist@yahoogroups.com
Sent: Tuesday, April 01, 2008 9:45 AM
Subject: (VOUG) Dates in export log files
Folks,
We are doing daily exports as part of our backup strategy. We are
working in a windows environment and with Oracle 10.0.2.0.3.
I would like to see a time the export started in the export log file
and the time the export completed in the same log file.
Here is what I have tried. If I create a log file using notepad, and
on the command line say: call time /t >> cb190t3.log, it will put the
time in there fine.
Then if I run my export and tell it to put the results in the same
log, it will overwrite what I have already entered. So I need some
help figuring out how to put the time it started, the export log, and
the time it finished.
Thanks in advance,
Bill Buker,
Enterprise Database Manager
Swansons Services
whbuker@...
Bill -
I don't work on windows much so I am not familiar with the commands, but
how about the following steps.
1. Capture the start time in a file - start_time.log
2. Run the export
3. Capture the end time in a file - end_time.log
4. Concatenate start_time.log with export.log with end_time.log
HTH
-Bill
wbuker wrote:
>
> Folks,
>
> We are doing daily exports as part of our backup strategy. We are
> working in a windows environment and with Oracle 10.0.2.0.3.
>
> I would like to see a time the export started in the export log file
> and the time the export completed in the same log file.
>
> Here is what I have tried. If I create a log file using notepad, and
> on the command line say: call time /t >> cb190t3.log, it will put the
> time in there fine.
>
> Then if I run my export and tell it to put the results in the same
> log, it will overwrite what I have already entered. So I need some
> help figuring out how to put the time it started, the export log, and
> the time it finished.
>
> Thanks in advance,
>
> Bill Buker,
> Enterprise Database Manager
> Swansons Services
> whbuker@... <mailto:whbuker%40swansons.net>
>
>
Folks,
We are doing daily exports as part of our backup strategy. We are
working in a windows environment and with Oracle 10.0.2.0.3.
I would like to see a time the export started in the export log file
and the time the export completed in the same log file.
Here is what I have tried. If I create a log file using notepad, and
on the command line say: call time /t >> cb190t3.log, it will put the
time in there fine.
Then if I run my export and tell it to put the results in the same
log, it will overwrite what I have already entered. So I need some
help figuring out how to put the time it started, the export log, and
the time it finished.
Thanks in advance,
Bill Buker,
Enterprise Database Manager
Swansons Services
whbuker@...
<snip>
Did the (+) notation used in outer joins "go away" in version 10g?
</snip>
No. But perhaps it should.
The ANSI OUTER join syntax is more readable and now the preferred
method as stated in the Oracle documentation set. See
http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/queries00
6.htm#i2054012
where it states:
"Oracle recommends that you use the FROM clause OUTER JOIN syntax
rather than the Oracle join operator. "
More details on why can be found in the link.
Nope. I use it all the time.
-----Original Message-----
From: VOUGlist@yahoogroups.com [mailto:VOUGlist@yahoogroups.com]
On Behalf Of Larry Blankenship
Sent: Thursday, October 18, 2007 4:07 PM
To: VOUGlist@yahoogroups.com
Subject: *VOUG* Oracle 10g - outer joins
Hiya All,
Did the (+) notation used in outer joins "go away" in version
10g?
Curiously yours,
LB.
==========================
Lawrence Blankenship '07
Hollins University
Computer Services
540-362-6487
==========================
Larry - The session presentation handouts from our conference earlier this month
are posted and ready for download!
Here's a direct link: http://www.voug.org/presentations.asp
You can click on the presentation title to download its handout (note that some
presenters don't have handouts, so if we didn't receive one then there won't be
a link in the title)
---
Craig Warman
VOUG Listserv Moderator
--- Larry Blankenship <lblankenship@...> wrote:
> Hiya All,
>
> I was a first time participant at the VOUG Conference held earlier
> this month. (The best conference I have been to in recent memory, hands
> down.) Did I understand correctly that session presentations would be
> made available to members of this listserv? Perhaps it is already
> available, and I missed it?
>
> Thanks!
>
> J
>
>
>
> ==========================
>
> Lawrence Blankenship
>
> Hollins University
>
> ==========================
>
>
Hiya All,
Did the (+) notation used in outer joins "go away" in version 10g?
Curiously yours,
LB.
==========================
Lawrence Blankenship '07
Hollins University
Computer Services
540-362-6487
==========================
Hiya All,
I was a first time participant at the VOUG Conference held earlier
this month. (The best conference I have been to in recent memory, hands
down.) Did I understand correctly that session presentations would be
made available to members of this listserv? Perhaps it is already
available, and I missed it?
Thanks!
J
==========================
Lawrence Blankenship
Hollins University
==========================
VOUG Membership - Well, today's the day - the last chance for you to take
advantage of the discount we offer to our members and past attendees! It's for
our big Fall conference in a few weeks: October 4th and 5th (Thurs & Fri) to be
exact, in Charlottesville, VA.
How To Get The Discount
-----------------------
When you fill out the conference registration form at http://www.voug.org you'll
see a field marked "VIP Passcode". Type the word MEMBER in that field, and make
sure you choose "VIP Passcode" in the "Registration Rate" drop-down box. This
gets you through the door for $235 for both days - but make sure you do it
before COB today!
The Keynote
-----------
In case you haven't heard, Oracle has really stepped up its support of the user
group community, and our keynote speaker is a prime example. He's Charles
Garry, Director, Product Management of Oracle Server Technologies, and his
keynote address will focus on how organizations can leverage 11g to achieve
infrastructure agility. This is an excellent choice - right now, IT
organizations continue to struggle with how the demands of their consumers (fast
turn-around times, flexibility, high availability) can be reconciled with the
practical limitations of the technology. It's a great opportunity to learn how
Oracle's engineers have addressed those issues with 11g, and how you can take
practical advantage of those advances.
Mr. Garry brings over 20 years of IT experience to the table. He has served as
the former Vice President and Director for META Group’s Technology Research
Services and has worked with hundreds of companies delivering support and
education in database design, performance tuning, backup/recovery, licensing,
and negotiation strategies. He presents regularly at Oracle World, IOUG, IDUG,
Teradata Partners and the MySQL User Conference, and was the author of a regular
column for eWEEK.com. This is a guy that understands the industry and knows the
technology.
See you in Charlottesville!
Craig Warman
VOUG Listserv Moderator
VOUG 2007
Doubletree Charlottesville Hotel
Charlottesville, VA
October 4-5, 2007
http://www.voug.org/
VOUG Membership - As I mentioned in the last presentation highlights, Oracle
security has become a dominant theme in our line of work. And so it follows
that it's also one of the largest tracks in this year's VOUG conference.
Discount for VOUG Members
-------------------------
If you haven't already registered, you'll definitely want to take advantage of
our discount to members that ends on Friday. When you fill out the conference
registration form at http://www.voug.org you'll see a field marked "VIP
Passcode". Type the word MEMBER in that field, and make sure you choose "VIP
Passcode" in the "Registration Rate" drop-down box. It's that easy - but you
have to do it before Friday the 14th.
Presentation Highlights
-----------------------
Here's the second of two rounds of highlights for security-related
presentations:
60 Security Tips in 60 Minutes
Kenny Smith, Consultant
You traveled all this way to the conference to either relax, network, vacation,
or learn something new. Recently, database security has been a hot topic that
needs attention. During this presentation, you'll get a boatload of security
tips and tricks - including encryption, hacking, and auditing - you'll find
helpful back at your office.
A New Look at a Popular Attack Vector on Databases: SQL Injection
Dan Sarel, Sentrigo
SQL injection is still one of the top threats to database security. While some
SQL injection attacks can be prevented using simple methods, others exploit
vulnerabilities that are far more difficult to detect and address. We will
explain and demonstrate such attacks and show how they can be stopped.
How Can Oracle Production Data Be Securely Used in a Test System?
Ulf Mattsson, Protegrity
Production data is in many cases needed to ensure quality in system testing. Key
data fields that can be used to identify an individual or corporation need to be
cleansed to de-personalize the information. A solution must be based on secure
encryption, robust key management, separation of duties, and auditing.
Database Security and Compliance—Oracle Solutions
Ran Pan, Consultant
Data security is one of the most crucial elements in today's business and
securing the database is a complex endeavor. To protect your data assets against
any internal and external threats requires integrating security policies,
measures, and technologies. This presentation will review common
vulnerabilities in database security, discuss the current challenges and steps
to take to protect the enterprise data assets, and offer an in-depth insight
into Oracle security architecture and models, and solutions.
------
See you in Charlottesville!
Craig Warman
VOUG Listserv Moderator
VOUG 2007
Doubletree Charlottesville Hotel
Charlottesville, VA
October 4-5, 2007
http://www.voug.org/
VOUG Membership - We're just a few weeks away from our Fall conference on Oct
4-5 (Thurs/Fri) in Charlottesville, VA. For those of you who haven't already
registered, you'll definitely want to take advantage of our discount to members
that ends on this Friday, September 14th.
How To Get The Discount
-----------------------
When you fill out the conference registration form at http://www.voug.org you'll
see a field marked "VIP Passcode". Type the word MEMBER in that field, and make
sure you choose "VIP Passcode" in the "Registration Rate" drop-down box. It's
that easy - but you have to do it before Friday the 14th.
Presentation Highlights
-----------------------
As you know, Oracle security is a very hot topic, and one of the largest tracks
in this year's conference. Here's the first of two rounds of highlights for
security-related presentations:
The Data Protection Landscape: Integrating Data Auditing with a Layered Defense
Brad Foreman, Tizor Systems
There are many approaches to protecting data including data auditing, data
monitoring, encryption, data leakage prevention, endpoint monitoring, and
others. Do you know which combination of approaches is best for your company?
In this presentation we will discuss where the various data protection
technologies fit into an effective data security strategy and provide
information on how to build a layered data protection defense system for your
organization.
Better R11i Security in 3 Days - Keeping the Bad Guys Away
Randy Giefer, Solution Beacon
Terrorism, identity theft, 9/11. It's no longer a safe world, and corporate
data needs to be protected from not only the external bad guys, but also the
internal ones as well! Many companies believe this won't happen to them - until
it's too late. This presentation is the second in the series following the
popular "30 Minute Release 11i Security - Keeping the Bad Guys Away" and
provides real-world examples and best practices of how substantial security
benefits can be obtained in just a few days. Security tips and tricks specific
to the Oracle Applications will also be provided to enable administrators to
protect their data from "the bad guys."
An Enterprise Database Security Project—A Case Study
Ulf Mattsson, Protegrity
This session is a case study about an Enterprise Database Security project
including the strategy that focuses on Oracle Database security. It presents the
current state of database security tools and processes, the current needs of a
typical enterprise organization, and a plan for evolving the database security.
It includes the current state of database security tools for Oracle8, 9, and 10,
the current needs of a typical enterprise organization, and a plan for evolving
the database security.
Data Privacy...The Internal Threat
Eric Offenberg, Princeton Softech
Privacy breaches are making headlines, as organizations scramble to protect the
confidentiality of their critical customer and business data. While companies
are making great strides in protecting data privacy in production application
environments, the idea of implementing similar strategies in their testing
environments is often overlooked. Taking a proactive strategy to combat this
internal threat will remove this vulnerability within your enterprise. Join us
for a presentation on combating the internal threat to your application
databases and learn how to protect your organization.
------
See you in Charlottesville!
Craig Warman
VOUG Listserv Moderator
VOUG 2007
Doubletree Charlottesville Hotel
Charlottesville, VA
October 4-5, 2007
http://www.voug.org/
Hi!
I had a bad install of a homegrown Siebel application with Oracle 8i
as a back end. It was removed and reinstalled.
My problem I lost my oracle ODBC connection to my main application. I
have an error message saying that I need:
* orancrypt8.dll.
Can anyone point me in the right place? My company has some sort of
relationship with Oracle but I am far removed from that and do not
have that option.
Regards,
Andrew
Hiya All,
If someone has recently gone through the Oracle Certification process
and is willing to share their experiences, I sure would like to hear
from you.
Drop me an e-mail directly if you have the time...
Thanks
LB.
==========================
Lawrence Blankenship '07
Hollins University
Computer Services
540-362-6487
==========================
VOUG Membership:
Advance registration is now underway for the big two-day statewide meeting in
Charlottesville this coming October 4th & 5th. Now, the general public will be
paying $260 to attend this meeting ($320 after September 10th), but VOUG
listserv members always get an extra discount. If you register before September
10th, the price drops to $235. Pretty cool.
Never been to a VOUG conference before? Then you owe it to yourself to come see
why participants consistently rate VOUG as the conference that "exceeds
expectations":
- Personal, relaxed atmosphere
- Top-notch presenters
- Excellent food and beverages
- No stampeding crowds
And you won't have to climb aboard a cross-country flight, either - it's all
right here Charlottesville, just down the road from Thomas Jefferson's
Monticello. Plus it's a Thursday/Friday conference so you can stretch it into a
long weekend.
How To Get The Discount
-----------------------
When you fill out the conference registration form at http://www.voug.org you'll
see a field marked "VIP Passcode." Type the word SPECIAL in that field, and
make sure you choose "VIP Passcode" in the "Registration Rate" drop-down box.
It's that easy - but you gotta do it by September 10th!
See you in Charlottesville!
Craig Warman
VOUG Listserv Moderator
VOUG 2007
Doubletree Charlottesville Hotel
Charlottesville, VA
October 4-5, 2007
http://www.voug.org/
As you may've heard, a call for papers closes soon for the VOUG conference this
coming October 4-5 in Charlottesville, Virginia. If you've ever considered
presenting at a user group conference - or, if it's been awhile and you'd like
to get back into the user group community - I'd like to encourage you to give
this one a shot.
Now, to those of you who are relative newcomers to Oracle, I would like to
encourage your participation as well. Many times people think they have to
submit some really deep technical paper to get considered. That is not the
case. In fact, many attendees would really like to see presentations that cover
the basics. Things like "Here is an overview of what this product does and here
is what we had to go through to get it set up in our shop" or "Here are the top
ten things you need to know to get started with this product."
The point is, if you are working with Oracle products and have tips or advice
you're willing to give, a story to tell, or have figured out some neat way to
"get the job done" then we'd really like you consider sharing it. One other
thing - this doesn't have to be a one-person show - you are welcome to "tag
team" with other members of your group. That takes the burden off of you to do
it all alone, plus it's kind of fun.
Complete details about how to submit your abstract can be found at the
conference website:
http://www.voug.org/
We look forward to receiving your abstract!
Craig
PS. One more thing - The call for papers is open until Tuesday, July 31st. We
won't be extending that deadline, so go ahead and get your submission in this
weekend!
Hello folks,
Can anyone help me by giving me information on good Oracle
financial/apps training centers in Virginia. Any help would be greatly
appreciated.
Thanks
Well the VOUG conference crew is officially back in action! We're hard at work
preparing for our Fall conference, and it's gonna be great. We've got the
Doubletree Hotel's meeting space reserved for us this coming October 4-5 in
Charlottesville, Virginia.
As you know, one of the very best things about our conferences (besides the food
of course) are the technical sessions. This is where our members share their
technical knowledge and expertise with their peers. You don't have to be some
big-name consultant to do that, either - presentations are selected based on
their technical content and relevance to the Oracle community. So if you've got
tips or advice you're willing to give, a story to tell, or have figured out some
neat way to "get the job done" then we'd like to extend an invitation for you to
share it with the group!
To submit an abstract, please visit our website at http://www.voug.org.
Accepted speakers receive complimentary registration to the conference. The
deadline for submissions is Tuesday, July 31, 2007.
Yes, it's definitely worth your time!
Craig Warman
VOUG Listserv Moderator
Hi there Virginia Oracle User's Group!
I recently joined the group and am very excited about Oracle career
opportunites in VA! In fact I did a little research on both monster
and careerbuilder, and found that there are alot more opportunities in
VA than in any other state that I was looking to relocate to.
Currently, I am trying to complete my Oracle 10g training, and to take
my certification exams.
Just wanted to ask your advice and help:
Would you have any advice on preparing and passing the exam?
Any ideas on how I could attain some work experience during my
preparation?
Where would be the most opportunity for me after certification?
What ways can I start and develop my career as a DBA in VA?
Look forward in hearing your responses.
Thanks,
Stanley
I realize Oracle has currenty only certified Oracle 10gr2 clinet on
Vista. Does anyone know if Oracle 9i client will run without errors on
Vista?
Thanks.
Greg
I have a small company running an Oracle app on a hosted server. I
have gotten some shared memory and permission errors and need to
reinstall Oracle. Can someone provide that service? Email directly
at steve@.... Thanks
aliases cannot be referred to in the select list, or anywhere else for that
matter, except in the order by clause
but you can put your query in an in-line query and then reference the aliases in
the outer query
for instance
select .... cases_this_month || ' -- ' || dollars_this_month ....
from (
select ...
, brk.division division
, SUM((NVL(rctl.quantity_invoiced,0)* NVL(msi.attribute13,1)) +
(NVL(rctl.quantity_credited,0)* NVL(msi.attribute13,1)))
cases_this_month
SUM(NVL(rctl.revenue_amount,0)) dollars_this_month
, msi.attribute12
... and the rest of your original query here
)
----- Original Message -----
From: oamen
To: VOUGlist@yahoogroups.com
Sent: Wednesday, February 14, 2007 3:29 PM
Subject: (VOUG) Concatenating alias columnms
HI,
I am trying to concatenate two column alises and am getting an error.
If I use only one alias and keep the other column as it is, the
concatenation works fine..But if I use aliases for two columns and try
to concatenate the two, it doesn't work.
The statement is like this...
-----
, brk.division division
, SUM((NVL(rctl.quantity_invoiced,0)* NVL(msi.attribute13,1)) +
(NVL(rctl.quantity_credited,0)* NVL(msi.attribute13,1)))
cases_this_month
SUM(NVL(rctl.revenue_amount,0)) dollars_this_month
, msi.attribute12
here I want to be able to concatenate cases_this_month and
dollars_this_month..
Any help would be appreciated.
Thanks
Asgar
[Non-text portions of this message have been removed]
HI,
I am trying to concatenate two column alises and am getting an error.
If I use only one alias and keep the other column as it is, the
concatenation works fine..But if I use aliases for two columns and try
to concatenate the two, it doesn't work.
The statement is like this...
-----
, brk.division division
, SUM((NVL(rctl.quantity_invoiced,0)* NVL(msi.attribute13,1)) +
(NVL(rctl.quantity_credited,0)* NVL(msi.attribute13,1)))
cases_this_month
SUM(NVL(rctl.revenue_amount,0)) dollars_this_month
, msi.attribute12
here I want to be able to concatenate cases_this_month and
dollars_this_month..
Any help would be appreciated.
Thanks
Asgar
Just a quick message to let you know that the discount to VOUG members for the
upcoming SEOUC conference ends on Thursday. SEOUC, by the way, is taking place
in Charlotte this coming March 1st & 2nd. Kevin Loney - bestselling author of
"Oracle Database 10g: The Complete Reference" and "Oracle Database 10g DBA
Handbook" - is the keynote, followed by two days of superb technical training:
http://www.seouc.com/presentations_abstracts.htm
Now, about the discount. Just go to the registration form on the conference
website at http://www.seouc.com and and choose "VIP passcode" on the dropdown
registration rate menu, then enter the word SPECIAL in the "VIP Passcode" field.
That'll bring your final cost down to $220 and some change, which is a lot less
than what the general public pays.
Craig
Folks, just a quick reminder that *today* is the last day for the
discounted $135/night room rate for SEOUC attendees at the Renaissance
Suites Hotel in Charlotte <http://www.renaissancehotels.com/CLTBR>.
You won't get that sort of price from any of the discount travel sites -
my last check on hotels.com was $189/night.
You'll need to call them at 704.357.1414 or 800.HOTELS1 and mention the
SEOUC conference to get this discounted rate.
See you in Charlotte this coming March 1st & 2nd at the Ninth Annual
SouthEast Oracle User's Conference (SEOUC)!
Craig
Our 1st set of books has two companies [01,02]. The inter-company
account default on company 01 is acct 01-1367. On company 02, the
default is 02-1367. When an entry is made in Company 01, using a
Company 02 Cost Center, the inter-company transaction is created in
the background, crediting/debiting Company 01-1367 and
debiting/crediting Company 02-1367.
We now have added a third company [03] which is in its own set of
books. So when a Company 03 Cost Center is keyed in Company 01 an
inter-company transaction should be created crediting/debiting Company
01-1370 in the 1st set of books and debiting/crediting Company 03-1370
in the 2nd set of books. Can this be done?
You want to get in touch with the Oracle Applications Users Group
(OAUG). Find them at <a
href="http://www.oaug.com/">http://www.oaug.com/</a>. By the way -
coming up in April is the second annual Collaborate conference, the
co-located conferences of OAUG, the Independant Oracle Users Group
(IOUG), and Quest, the users group for JD Edwards software users.
Last year in Nashville was a fine conference, and this year in Las
Vegas, building on that experience, it should be even better.
--- In VOUGlist@yahoogroups.com, "Sherry" <sobershea@...> wrote:
>
> Hello,
>
> I am looking for an Oracle Financials User Group - where the focus
is
> not the technical [i.e. setup, updates] but rather using Oracle. I
am a
> Financial Analyst with many years of Oracle use but there are still
> things that stump me. We are currently using version 11i. For
instance,
> I have created many Rules in Oracle [setup, financials, flexfields,
key,
> rules] but am struggling with trying to make one work. It would be
great
> to find a support group!
>
> Does anyone have suggestions?
>
> Thanks in advance,
>
> Sherry
>