Home » SQL & PL/SQL » SQL & PL/SQL » recover tables (urgent) (10)
recover tables (urgent) [message #357640] Thu, 06 November 2008 02:15 Go to next message
maheshmhs
Messages: 93
Registered: October 2008
Location: Nepal
Member
hi

Accidently, all tables of a schema have been dropped. When i select * from tab i can still see that they exist in Recyclebin.
Recycle bin has not been purged yet. How can i get those tables back?

This is very much crucial. Please help?

thanx
Re: recover tables (urgent) [message #357641 is a reply to message #357640] Thu, 06 November 2008 02:19 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Look up the syntax for the flashback table command
Re: recover tables (urgent) [message #357642 is a reply to message #357640] Thu, 06 November 2008 02:20 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

Try using Flashback option .
Look in this Orafaq link for reference.

Smile
Rajuvan.

[Updated on: Thu, 06 November 2008 02:21]

Report message to a moderator

Re: recover tables (urgent) [message #357650 is a reply to message #357640] Thu, 06 November 2008 02:51 Go to previous message
maheshmhs
Messages: 93
Registered: October 2008
Location: Nepal
Member
THANX.

I don't know how he solved it. The tables are now right there.

thanx to my dba Saurav Thakur.

Previous Topic: Create and Select Statement inside a function
Next Topic: Question on EXEC procedures stored in variables
Goto Forum:
  


Current Time: Sun Dec 04 06:42:09 CST 2016

Total time taken to generate the page: 0.07755 seconds