Database Administration (MOSC)

MOSC Banner

get the last modified time up to 45 days

edited Sep 15, 2009 3:26AM in Database Administration (MOSC) 11 commentsAnswered
Our one application created some temp tables frequently. After some days later, the application maybe won't use these tables any more. How can we check those tables which haven't been modified for more than 45 days, then we can drop these tables? I understand that "select
scn_to_timestamp(max(ora_rowcn)) from uac_1234" will give me the last modified
time for table uac_1234. But it just can give less than 5 days timestamp, which
parameter I need change then oracle can keep 45 days timestamp for the modified
time?

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