For various reasons I had to remove a 9i release 2 database today, which had
originally had its creation scripts created by DBCA so they lived in
$ORACLE_BASE\ADMIN\$DB_NAME\scripts, prior to recreation. I now see the
rationale for all those db templates as the act of using DBCA to remove the
database and datafiles also removes the creation scripts,init.ora etc etc
from the server. I'd suggest if you do use DBCA to create your
scripts/databases for you then you also either create a template from the db
once you are happy with it or else copy the scripts elsewhere.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Mon Feb 24 2003 - 11:09:57 CST
