On Wed, 6 Jan 1999 16:21:15 -0500, Carlo Di Mascio wrote:
>I would like to copy database A to database B without doing an
>import/export. The import takes 36 hours. Is there a better way? As someone
>managed to re-create the control files and modify the header in the dbf
>files to use a different database name? There must be a way.
If you are able to completely shutdown the instance completely, then
it is possible to copy the datafiles to a new location. Before
shutting down the instance do an ALTER DATABASE BACKUP CONTROLFILE TO
TRACE. That trace file contains a SQL command and some extra lines
that need to be edited out. Further edit the trace file to reflect the
new datafile locations and ensure that there is an init.ora for the
new instance. That's all she wrote.
--
Barth Siemens
Change the email address from nospam to barth.
Received on Sun Jan 10 1999 - 21:50:56 CST
