Recycle Bin automatic purging

  • This script creates a job that automatically purges all objects (tables) in recycle bin that are older than 7 days (edit the default in the installation script if necessary)
  • Job, by default, runs every day at 7 a.m.


  • connect to pdb-backup
   $ cd ~/production/recyclebin
   $ sqlplus system@<db_name> @purge_old_recyclebin
  • please ignore the error of dropping non-existing job


  • connect to the target database
  • to disable automatic purging please execute the following command:
  • to enable it (please set BYHOUR=... parameter to the hour the purging should start - important in streams environment to allow it to run first on the capture side and then after few hours on the apply side):

This topic: PSSGroup > PhysicsDatabasesSection > DbaArea > RecycleBinPurging
Topic revision: r3 - 2007-09-03 - DawidWojcik
This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback