Re: Automatic Undo Management Mode
- From: SJHussain@xxxxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sat, 28 Aug 2004 11:33:03 +0300
Is parameter UNDO_MANAGEMENT = AUTO
and UNDO_TABLESPACE set to UNDOTABLESPACE?
check the undo_management parameter in theinit/spfile.
Best Regards,
Syed Jaffar Hussain
OCP
"fahd mirza"
<fahd-m@xxxxxxxxx
pk> To
Sent by: "Active DBA"
oracle-l-bounce@f <oracle-l@xxxxxxxxxxxxx>
reelists.org cc
Subject
08/28/2004 11:32 Automatic Undo Management Mode
AM
Please respond to
oracle-l@freelist
s.org
I am trying to create a database manually in Oracle 9i. But getting this
error, when I try to run the script for database creation.
SQL> @d:\prod\create_prod.sql
create database prod
*
ERROR at line 1:
ORA-30014: operation only supported in Automatic Undo Management mode
from oracle support
Cause: the operation is only supported in automatic undo mode.
Action: restart instance in Automatic Undo Management mode before
retrying operation.
How can I restart instance in Automatic Undo Management mode?
regards,
Fahd
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Visit us on www.alfransi.com.sa
====== Banque Saudi Fransi - Privacy Notice ======
This message is intended only for the person or entity to which it is
addressed and may contain confidential and/or privileged material. Any
use of this information by persons or entities other than the intended
recipient is prohibited. If you have received this in error, please
contact the sender and delete the material from your computer. Any
opinions and other information contained in this message that do not
relate to the official business of Banque Saudi Fransi shall be
understood as neither given or endorsed by it. Although precautions
have been taken to ensure no viruses are present in this email, BSF
cannot accept responsibility for any loss or damage arising from the
use of this email or attachments.
====== Banque Saudi Fransi - Privacy Notice ======
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
