Re: Automatic Undo Management Mode

From: <SJHussain_at_alfransi.com.sa>
Date: Sat, 28 Aug 2004 11:33:03 +0300
Message-ID: <OF91C14625.475F0991-ON43256EFE.002ED38F-43256EFE.002EF8C7@AlFransi.com.sa>

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_at_aero.com.                                             
             pk>                                                        To 
             Sent by:                  "Active DBA"                        
             oracle-l-bounce_at_f         <oracle-l_at_freelists.org>            
             reelists.org                                               cc 
                                                                           
                                                                   Subject 
             08/28/2004 11:32          Automatic Undo Management Mode      
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
             oracle-l_at_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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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

Received on Sat Aug 28 2004 - 03:28:56 CDT