Re: Copying Database to new SID

Never mind ! I got it to work, but thanks for everybody's help including Conner McDonald. His reply to another post was the answer.

The first line after the create control file commad should be; SET database.

Thanks Jerry

Jerry <america_at_usa.com> wrote in message news:fstw5.3446$Ds.20164_at_news4.atl...
> I tried to create a copy of my database to a new sid
> by the following method.
>
> 1) Backup control file to trace
> 2) edit the trace file to reflect new Database name and Location
> of database files.
> 3) Copied all data files to new location
> 4) Copied and edited the Init.ora file to reflect new Sid.
> 5) Rename the trace file to *.sql
> 6) Ran the sql script which should create the new control file.
>
> But got the following errors;
> What step did I miss ?
>
>
>
> ORA-01503: CREATE CONTROLFILE failed
> ORA-01161: database name PROD in file header does not match given name of
> TEST
> ORA-01110: data file 1: 'C:\ORACLE8I\ORADATA\TEST\SYSTEM01.DBF'
> ORA-01507: database not mounted
>
>
>
Received on Fri Sep 15 2000 - 14:21:44 CDT