How To Manage The Recycle Bin

USER RECYCLE BIN MANAGEMENT

  • Objects in a user's recycle bin.
      SELECT COUNT(*) FROM <user>.recyclebin;
  • Purge a user's recycle bin.
      PURGE <user>.recyclebin;

DATABASE RECYCLE BIN MANAGEMENT

  • Objects in the database's recycle bin.
      SELECT COUNT(*) FROM dba_recyclebin;
  • Purge the database's recycle bin.
      PURGE dba_recyclebin;
  • Switch the recycle bin function on or off.
      ALTER SYSTEM SET recyclebin = ON | OFF;
© copyright 2001-2014 ABCdba.com | all rights reserved