purge DBA_RECYCLEBIN using droptime info
Hi,
I need to create a "maintenance procedure" to purge all objects in DBA_RECYCLEBIN older then xx days using droptime column data.
As in purge command don't exists the"where" clause, what's the easiest way to do what i need?
Thankyou
I need to create a "maintenance procedure" to purge all objects in DBA_RECYCLEBIN older then xx days using droptime column data.
As in purge command don't exists the"where" clause, what's the easiest way to do what i need?
Thankyou
Paolo
0