Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

dbca scripts from 10gr2

Ray Stell

2006-05-19


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


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.