Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How copy database unless export/import

How copy database unless export/import

From: Tof <None_at_ForNotSpam>
Date: Mon, 28 Feb 2005 14:24:28 +0100
Message-ID: <42231d3d$0$11679$8fcfb975@news.wanadoo.fr>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US