Database Administration (MOSC)

MOSC Banner

purge DBA_RECYCLEBIN using droptime info

edited Mar 11, 2010 7:50PM in Database Administration (MOSC) 12 commentsAnswered
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

Paolo

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center