GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  SQL
Go To First  |  Previous Question  |  Next Question 
 SQL  |  Question 81 of 171    Print  
In Oracle10g sqlplus, how do you find the tables that have been dropped?

  
Total Answers and Comments: 3 Last Update: February 06, 2008     Asked by: oradba 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
April 07, 2006 00:58:40   #1  
gomathi.e        

RE: In Oracle10g sqlplus, how do you find the tables t...

select * from recyclebin;

using this query we can see the tables which are dropped. its applicable only in oracle 10g.


 
Is this answer useful? Yes | No
August 04, 2006 06:37:40   #2  
Suresh        

RE: In Oracle10g sqlplus, how do you find the tables t...

You can use this command to retrieve the dropped table simply by querying
FLASHBACK TABLE <table_name> TO BEFORE DROP;

you can also query this to view the objects that can be undropped
SHOW RECYCLEBIN


 
Is this answer useful? Yes | No
February 06, 2008 23:47:48   #3  
g_sidhu Member Since: August 2007   Contribution: 122    

RE: In Oracle10g sqlplus, how do you find the tables that have been dropped?

When you drop a table normally the database does not immediately release the space associated with the table. Rather the database renames the table and places it in a recycle bin where it can later be recovered with the FLASHBACK TABLE statement if you find that you dropped the table in error.

FLASHBACK TABLE RECYCLETEST TO BEFORE DROP;


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape