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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Temp Copy of Database

Re: Temp Copy of Database

From: Pierre Cote <pierrem.cote_at_cgi.ca>
Date: 1997/07/29
Message-ID: <33DDEAB4.406D@cgi.ca>#1/1

bluebody 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?

Hi,

If you have done an export to backup your data, simply import the data in the table. If your already have data in the table then just copy that data in another table previously created with no rows.

Pierre Cote Received on Tue Jul 29 1997 - 00:00:00 CDT

Original text of this message

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