dbca scripts from 10gr2

From: Ray Stell <stellr_at_cns.vt.edu>
Date: Fri, 19 May 2006 11:49:55 -0400
Message-ID: <20060519154955.GB19580@cns.vt.edu>

I generated some scipts with 10.2.0.1 to see what they looked like. I posted this at metal ink and got no response.

dbca generated scripts used to use the CREATE DATABASE command. I was looking at the script generated from 10.2.0.1 on linux and I see this command is not used. The script uses:

Create controlfile reuse set database ... exec dbms_backup_restore.zerodbid(0);
SQL> shutdown immediate;
ORA-01109: database not open
startup nomount pfile=...
Create controlfile reuse set database ...

This is unexpected. Why is this the prefered method for creating a db? Is this some sort of improvement via this method?

--
http://www.freelists.org/webpage/oracle-l

Received on Fri May 19 2006 - 10:49:55 CDT