Please, try ORADIM command utility.
Ferry Situmorang:
Using Oracle 8.1.7 Designer 6i R4
PT Perkebunan Nusantara XIII (Persero)
Pontianak-Indonesia
http://www.ptpn13.com
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, March 04, 2002 10:23 PM
Take a backup of the controlfile statement by doing a
alter system backup controlfile to trace;
Then use this script to create a new controlfile with the new SID
after u have transferred all the datafiles, redolog files and archive
log files. The first line of the create controlfile script
it's doable. You will need to do a number of things before you can open
the database, including recreating the controlfile (to change the sid)
and renaming all the datafiles to new locations (so you don't overwrite
the original database)
The easiest way (but not the shortest time) to do this
Rick, here is how I do it. Contact me if there are any questions.
Make a copy of 'prod' on LAWDB to 'test' on LAWDB from Cold Backup
Introduction
The 'prod' Oracle instance sometimes need to be replicated, on demand, for
testing and/or training purposes. The replication is done using a