Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

how works DBA_TAB_MODIFICATIONS

user8791033Nov 25 2020

I wonder how works the DBA_TAB_MODIFICATIONS.
How long is kept the data for a table? I have tables with timestamp on Dec/2019
What does it mean when a table is not in DBA_TAB_MODIFICATIONS? do it mean the table hasn't had (delete, insert, update) in a period? if yes, for how long?
I have a Schema with around 1000 tables, only around 300 appear in DBA_TAB_MODIFICATIONS

Added on Nov 25 2020

#11gr2, #database-and-application-migrations

4 comments

561 views