Wednesday, April 11, 2007

oracle 10g FlashBack function

It is a simple function act as recycle bin to store the drop table ... etc.
http://dbaoracle.itpub.net/post/901/271132
  • Issue one of the following statements:

    ALTER SESSION SET recyclebin = ON/OFF;
SELECT object_name, original_name FROM dba_recyclebin
The recycle bin table name is "dba_recyclebin"

How to purge the recycle bin:
PURGE TABLE BIN$jsleilx392mk2=293$0;
or
PURGE RECYCLEBIN;

Maybe you also can append PURGE after drop table statement.
DROP TABLE ABC PURGE;
then the table will direct delete not add to recycle bin.