Re: Just Plug it in ...

Hi,
Sorry, I have only 2 options for you. Others fail for a variety of reasons.

	Option #1: Bring up old database.  Export table, Import table into
new 			database.  
	Option #2: Bring up old database.  Use SQL*Talk to open 2 connections
(1 		old, 1 new).  Connect old system/mysyspwd;  
		Connect new system/mysyspwd; Copy 1.table to 2.table;

Unfortunately, the controlfile and logfiles are the only files with which you can use the REUSE option. See Alter database command in SQL reference.

Both options require both the system tablespace and the datafile/tablespace in question to be up at the same time. Whichever you choose, check that you have the physical space and memory to pull this off first. Sorry for the pausity of options.

Greg

Pinchas Nisenson wrote:
>
> This question has been on my mind for quite a while now.
> Let suppose for a second that I have a datafile that has been backed up
> using a unix utility. Two month later I discovered that somebody has
> deleted a table that happend to reside in this datafile.
> I do run in archive log mode. Have the logs etc ..
> After I copy the datafile from tape to disk into a separate file system
> I am trying to rename the datafile to the new name ( the old datafile).
> Alas Oracle informs me that media recovery is needed i.e. run forward
> all the updates from all the archiving logs ... I do not care for the
> updates. The only thing I want is to be able to get the lost table. It
> contains static data that has not changed since. Is there a way to tell
> Oracle just take the datafile and let me do what I have to do ?
> --
> Thanks ..
> =========================
> Pinchas Nisenson
> Data Base Manager
> University (of Calgary) Computing Services
> E-mail: nisenson_at_acs.ucalgary.ca
> Phone: (403) 220-4447
> Fax: (403) 282-9361
Received on Mon Dec 15 1997 - 00:00:00 CST