Re: Copying database to another instance possible ?

You can recreate by moving the datafiles - when you use the 'create controlfile' statement you have to use 'SET database' . Also use this if you are changing the database name.

Alex

sverzijl_at_hotmail.com wrote:

> Hi All,
>
> Can someone tell me what the common way is to copy/restore a database to
> another instance ?
>
> (e.g. in DB2 there is the command 'RESTORE DATABASE PROD INTO TEST' to
> accomplish this).
>
> In Oracle I only know of a full export/import of a database, but this is a
> very time consuming task. I tried copying the datafiles and recreating the
> controlfile from the 'backup to trace' (replacing the datafile paths to point
> to the new database location), but this doesn't work since Oracle checks the
> header of the datafile comparing the database name.
>
> There must be a faster way than a full export/import to copy a database, isn't
> there ?
>
> Regards,
>
> Simon Verzijl
> Devote
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Mar 09 1999 - 05:04:34 CST