(Source Code) Oracle: using recycling bin

Submitted by admin on Thu, 2008-06-19 15:12

Oracle: using recycling bin


Information about the objects in recycle bin:

SELECT object_name,
 original_name, type,
 can_undrop , can_purge ,
 droptime
FROM recyclebin

or

show recyclebin

Restore

flashback TABLE mytable TO before DROP;

Clear recycle bin

purge recyclebin;

 



GET ALERTS in EMAIL:

for FREE SMS ALERTS, SEND SMS ON placement-papers to 9870807070

Downloads | Post Your Resume | Jobs Alerts