Re: Temp Copy of Database

No easy answer here. If you can't use an machine or close your other database down for the restore time you have a tricky task that involves restoring the files changing the init file, renaming the database files and then bringing up the database.

It ain't difficult but I would get Oracle support to assist since they probably have the exact procedure documented.

Ian

"bluebody" <shimsoft_at_wport.com> wrote:

>I need to recover data that was deleted from a table. Admin manual says I
>can create a temporary copy of the database, export the data from the copy
>of the table, then import it into the current database. How do you create
>a temp copy of the database, start it and log into it without affecting the
>current database which is up and running?
Received on Fri Jul 25 1997 - 00:00:00 CEST