DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: error running create database script

  1. #1
    Join Date
    Oct 2002
    Posts
    18

    error running create database script

    I get the following error when i run my create database script:

    SQL> @C:\oracle\admin\newdb\create\createdb.sql
    CREATE DATABASE newdb
    *
    ERROR at line 1:
    ORA-30014: operation only supported in Automatic Undo Management mode


    I'm runing the script in Oracle 9i connected as sysdba.HOw can i run the script again?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Cause: the operation is only supported in automatic undo mode.
    Action: restart instance in Automatic Undo Management mode before
    retrying operation.

  3. #3
    Join Date
    Oct 2002
    Posts
    18

    command?

    do you know what the command is ...?

    Thanks

  4. #4
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    Looks like you have Oracle 9i installed. Can you send me the complete script? Oracle 9i now has Auto and Manual rollback management.
    Last edited by agasimani; 12-15-2002 at 12:10 AM.
    Agasimani
    OCP(10g/9i/8i/8)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width