Table retrieval [message #90793] |
Sat, 11 December 2004 05:31 |
K.Subrahmanian
Messages: 13 Registered: August 2004
|
Junior Member |
|
|
Hi,
I have drop a table and i don't have any backup,how do u retrieve the table..
Rgds
K.Subrahmanian
|
|
|
Re: Table retrieval [message #90795 is a reply to message #90793] |
Tue, 14 December 2004 02:13 |
Frank Naude
Messages: 4581 Registered: April 1998
|
Senior Member |
|
|
If you are running Oracle 10g (or above), you can undrop (flashback to before drop) the table. If not, your data is gone forever.
Best regards.
Frank
|
|
|