Create test database script in ORACLE 9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Create test database script in ORACLE 9i

  1. #1
    Join Date
    Feb 2001
    Posts
    39
    Hi All,
    Does anyone know where I can find the test script that creates the test database instance after installing Oracle 9i? Any help will be greatly appreciated.

    Thanks,
    Dee.
    God Bless

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Why don'y you just run CREATE DATABASE;?

  3. #3
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Din't ur 9i installation create a database.

    If its already created a database and u want to create a new test database.Just execute the following command

    alter database backup controlfile to trace;

    go to your trace directory and look for the latest trace file generated.This file will contain a database create script.Just run ur database in nomount stage and execute the command from the trace file.This will create a new database for u.

    cheese
    anandkl
    anandkl

  4. #4
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Alternatively use the Database Configuration Assistant to create the instance.

    If you want you can save the scripts rather than create the database straight away. That way you get a full create script that you can alter.

    NT/2000:

    Start -> Programs -> Oracle-OraName -> Configuration and Migration Tools -> Database Configuration Assistant

    UNIX:

    export DISPLAY=workstation:0.0
    $ORACLE_HOME/bin/dbca
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    This might be the appropriate therad:

    Has somebody managed to create a 9i DB defining both the UNDO tablespace and the DEFAULT TEMPORARY TABLESPACE in the same "CREATE DATABASE" statement using OMFs? I always got ORA-03113 (tried to reduce, increase the memory setting, nothing helped) and finally got fed up and created the tablespaces after the "CREATE DATABASE" statement. I did that in 9.0.1.1.1


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