| recover table without backup [message #459326] |
Fri, 04 June 2010 06:59  |
Riyasbasha
Messages: 25
Registered: March 2010
|
Junior Member |
|
|
Hi All
How to recover a table, without using backup (no backup) of a table and without using flashback (flashback off)techniques
can any one help me
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: recover table without backup [message #459384 is a reply to message #459380] |
Fri, 04 June 2010 10:00  |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Your archive logs are useless, if you don't have a backup.
You haven't said, but it sounds as though what you did was DELETE and COMMIT, a week ago. Why not try a flashback query? I bet nothing much has happened on your database since then, so it might work:
INSERT INTO table SELECT * FROM table AS OF TIMESTAMP (SYSTIMESTAMP - 8);
to put back all the rows that existed eight days ago.
|
|
|
|
| Re: recover table without backup [message #459385 is a reply to message #459384] |
Fri, 04 June 2010 10:08 |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
I bet no one has an undo tablespace (if OP has one) large enough to keep the last 8 days data.
Depending on the statement that deleted the rows, Log Miner can do the trick (of course database should be in ARCHIVELOG mode or doing nothing during the last week).
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
