Re: datafile

Normally, creating a database involves two scripts that are run from SVRMGRL. The first simply creates the SYSTEM tablespace and a datafile associated with it as well as the REDO log files and control files(locations of both are specified in INIT.ORA or CONFIG.ORA). The second script creates the ROLLBACK tablespace and other secondary initial tablespaces (USER, TOOLS, etc.) as well as rollback segments in the ROLLBACK tablespace. If you're on a Unix system there are example scripts provided by Oracle (CRDB.SQL and CRDB2.SQL). Look for them in the $ORACLE_HOME/svrmgr directory.

The CREATE statement should specify SYSTEM tablespace and one datafile (see the example files described above). The SYSTEM tablespace should be used solely for the data dictionary. All other data should be created in separate tablespaces after the CREATE DATABASE is executed. Hope this clears it up some.

Allan

Denis wrote in message <01be7393$db501d40$5a5167cf_at_95-mariandc>...
>I would like to make a clear understanding of the datafile in the create
>database. What would be the role of the datafile in the create statement?
>If I place the the datafile as an option in the create DB statement, does
>this mean that my data won't reside in a tablespace? And if I created a
>tablespace for the tables, then what would be inside the datafile that I
>defined during the create statement.
>
>Sorry for so many questions.
>
>TIA,
>
>Denis
Received on Sun Mar 21 1999 - 10:57:47 CST