-
Use Flashback Query to recover lost data
Hi All,
My database version is 10g. My Application Developer does a wrong action on table A : He deteled all rows on this table. He want to retore all data of this table. I think I must use FlashBack Query to get all data of this table, but if I do so, it would effect to others tables at the time I do Flashback Query. Are there any ways to use Flashback on only 1 table A and others tables is not effected?
Please help me.
Thanks in advance,
Sinh
-
err yeah, just do it on the table you want
-
-
flashback table to before drop;
-
Originally Posted by gopu_g
flashback table to before drop;
not going to help as the table wasnt dropped, data just deleted
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|