Database Security Products (MOSC)

MOSC Banner

dropped table modified date older than 45 days

edited Oct 8, 2009 7:13PM in Database Security Products (MOSC) 16 commentsAnswered
 Hi All,

I got a request from my customer, they want me to drop some tables modified date older than 45 days. I have searched all information from metalink and google, what I got just use dba_tab_modifications or user_tab_modification, but those two views just can provide 5 days information. If the modification information old than 5 days, I can't get anything. If any way I can  do this work?

Thanks a lot,

kelvin

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