Rauf Sarwar wrote:
> Tof wrote:
>
>>Hi all,
>>
>>I want to copy a database for test.
>>I create my controlfile, but when i want to reuse my datafile for
>>tablespaces, it don't go, because, in header file, it have got old
>
> name
>
>>for database.
>>
>>His message : (New DB -> TTT and old DB -> DBT
>>
>>ERROR at line 1:
>>ORA-01503: CREATE CONTROLFILE failed
>>ORA-01161: database name DBT in file header does not match given name
>
> of TTT
>
>>ORA-01110: data file 1: '/u01/oradata/TTT/system01.dbf'
>>
>>How i can do this, unless use export/import.
>>
>>Thanks
>>Christophe
>
>
> Please post the create controlfile command that you are using.
>
> I suspect you are using
> CREATE CONTROLFILE REUSE DATABASE "TTT" .......
> Instead of
> CREATE CONTROLFILE SET DATABASE "TTT" .......
>
> Regards
> /Rauf
>
Ok, i see, i take REUSE for SET.
The REUSE, is for copy database to another machine.
Thanks
Christophe
Received on Mon Feb 28 2005 - 08:18:25 CST
