Cakue by Yohan Yudanara

Do you know that Oracle Database 10g or later have recycle bin?
Dropped table will go to recycle bin, but deleted record will NOT go to recycle bin.

Here is the sample for dropping table:

create table coba(fieldcoba varchar(100));
insert into coba values('aaaaa');
drop table coba;

and then we restoring the table from recyclebin:

flashback table coba to before drop;

To empty recycle bin, we can use this command:

purge recyclebin;

For dropping the table and skip the recycle bin, use this command:

drop table coba purge;

Posted by Yohan Yudanara on Saturday, May 30, 2009 at 9:59 AM | Permalink