WARNING: This web is not used anymore. Please use PDBService.RecycleBinPurging instead!
 

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, from default, runs every day at 7 a.m.

Installaion

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

Edit | Attach | Watch | Print version | History: r3 < r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r2 - 2007-07-19 - DawidWojcik
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    PSSGroup All webs login

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