Home » Developer & Programmer » Designer » Table retrieval
Table retrieval [message #90793] Sat, 11 December 2004 05:31 Go to next message
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 Go to previous message
Frank Naude
Messages: 4420
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
Previous Topic: Ask Question
Next Topic: difference between oracle8i and oracle9i
Goto Forum:
  


Current Time: Wed Sep 17 15:04:44 CDT 2014

Total time taken to generate the page: 0.11184 seconds