Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Adding Additional Databases

Re: Adding Additional Databases

From: kumarg <kumarg_at_mindspring.com>
Date: 1997/09/23
Message-ID: <01bcc851$575ab5c0$11f47fc0@gaatlakumarg.atlantaga.ncr.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US