get the last modified time up to 45 days
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?
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?
0