Page 1 of 1

can any one tell query to delete the request which

Posted: Thu Apr 19, 2007 4:29 am
by yugeswara
can any one tell query to delete the request which r processed using sql statement

Posted: Thu Apr 19, 2007 7:13 am
by admin
Why you don't use the purge requests process? thanks

Posted: Fri Apr 20, 2007 7:00 am
by admin
You can use the CMCLEAN script by Oracle available on metalink, see the following note 134007.1.

Subject: CMCLEAN.SQL - Non Destructive Script to Clean Concurrent Manager Tables
Doc ID: Note:134007.1 Type: SCRIPT
Last Revision Date: 05-JAN-2007 Status: PUBLISHED