Database Administration (MOSC)

MOSC Banner

using log miner to know when a partition is last modified

edited Oct 22, 2015 10:05AM in Database Administration (MOSC) 3 commentsAnswered

Hi,

I need to make a job, to move segments (tables, table partitions) to a read only tablespace as long as their data never been modified since 2 Months or more.

dba_tab_modifications doesn't have the needed info "not for old partitions", I found out that I have to use the log miner, to know exactly when the table/partition was last modified!

when there is no easier way to do it, please tell me how to do it using the log miner.

Note:

I know that this could be done depending on the App logic, and move the segment automatically to a read only tablespace. in my situation this is not possible.

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