Re: datafile

The create database statement usually contains the datafile for the system tablespace and the datafiles for the redo_log segments.

Tablespaces reside within one or more datafiles. Without the system tablespace there is no database.

Oh, you should be sure to protect certain datafiles more than others, the controlfiles, the redo logs, and the system tablespace datafile. It is necessary to backup all datafiles (with certain exceptions on the redologs), but the controlfiles and system tablespace are more difficult to recover when lost.

Denis wrote:
>
> 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

--
Gerry Sinkiewicz
sinkiege_at_snet.net Received on Sun Mar 21 1999 - 08:36:41 CST