Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Adding Additional Databases
This is the best way to create the second database in my opinion. Create the first database and do a "alter database backup controlfile to trace" and then shut this database down. Copy the database files (dbf and redo) to a different location. The alter command creates a "create controlfile" script in the udump directory. Change this script for new database name, file locations. Set the ORACLE_SID in env variable to new instance, run this script and voila ... the new database. Received on Tue Sep 23 1997 - 00:00:00 CDT
![]() |
![]() |