Browse oracle-l: This Month's Archive • Main Archive Page • Related posts • Previous by Date • Next by Date

Creating a controlfile - language needed?

From: "J. Dex" <cemail_219@xxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Tue, 04 Oct 2005 09:39:05 -0400

When creating a controlfile from a trace file, is this wording simply removed or altered:

RECOVER DATABASE

ALTER SYSTEM ARCHIVE LOG ALL;

I have changed the other info to read
?CREATE CONTROLFILE REUSE DATABASE ?SID_NAME? RESETLOGS NOARCHIVELOG?
At the very bottom of the script I have changed it to read
?ALTER DATABASE OPEN RESETLOGS?

I am copying a database to a new server and all of the 200+ files will have a new directory structure (but will keep the same SID) so that is why I am creating a new controlfile.

_________________________________________________________________ Don?t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/

--
http://www.freelists.org/webpage/oracle-l