Re: Backup and restore the tablespace

If you don't have an export of the data, or the data in another system you can extract it from, then you are stuck. Unless you have a copy of the database on tape that you want to restore.

1. If you have the data in an export file, import it into a temporary table in another schema and 'insert...select..where...' the rows you want to copy across.
2. If you have it in flat files, just reload it with sqlloader or A.N.Other tool.
3. If all you have is a database backup, restore it on another system (or the current system with a new sid) and extract the data you want and reimport it, or copy it across a database link.

MotoX.

Collin Leung wrote in message <6nugb6$fj_at_is1.vtc.edu.hk>...
>What I want to do is to restore the accidentally deleted data.
>Please give me some advice.
>
>MotoX wrote in message
><899803356.14814.0.nnrp-10.c2de712e_at_news.demon.co.uk>...
>>Er, I think you are getting a bit confused over what 'recover' actually
>>means. It doesn't mean 'put my database back to a prior state'. It means,
>>'put my bad database back into it's last know good state', which is what
>you

[snip] Received on Wed Jul 08 1998 - 09:30:16 CDT