Home » Developer & Programmer » Designer » Table retrieval
Table retrieval [message #90793] Sat, 11 December 2004 05:31 Go to next message
Messages: 13
Registered: August 2004
Junior Member

I have drop a table and i don't have any backup,how do u retrieve the table..




Re: Table retrieval [message #90795 is a reply to message #90793] Tue, 14 December 2004 02:13 Go to previous message
Frank Naude
Messages: 4426
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.

Previous Topic: Ask Question
Next Topic: difference between oracle8i and oracle9i
Goto Forum:

Current Time: Fri Nov 27 04:34:30 CST 2015

Total time taken to generate the page: 0.10847 seconds