Re: control files on linux

Hi,

  The create database command creates the controlfiles for you in the location(s) specified in the initSID.ora . The create controlfile command is used to recreate the controlfile if you have lost all copies of the controlfile or to recreate the controlfile to change the database name or other parameters specified at database creation time like MAXDATAFILES. Regards,
Denny

In article <378DE93E.2277FFAD_at_tcimet.net>,   Esther Shaw <eshaw_at_tcimet.net> wrote:
> I'm running Oracle Enterprise Edition 8.0.5 on linux and have a
question
> about control files. The documentation says that the 'create
database'
> command creates the control files which on linux are defaulted to
> $ORACLE_HOME/dbs/ctrlSID.dbf unless otherwise specified. My
> understanding that "unless otherwise specified" means that I can put a
> line in my initSID.ora file that says control_files and specify
another
> directory.
>
> Does this mean that I don't use the 'create controlfile' command to
> create these files initially? Does the create database command
> automatically make my ctrlSID.dbf file? Is the 'create controlfile'
> command used for the system.dbf, tools.dbf, users.dbf, etc files?
>
> Thanks
> E Shaw
>
>

--
Denny Koovakattu
denny_at_vitalsol.com
http://vitalsol.com/

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 15 1999 - 11:21:46 CDT