Re: How copy database unless export/import

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 28 Feb 2005 05:48:32 -0800
Message-ID: <1109598512.418713.141640@z14g2000cwz.googlegroups.com>

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 Received on Mon Feb 28 2005 - 07:48:32 CST