UNUSED TABLES
Hi,
How to find list of tables with last access date ( Based on "select" statement).
The purpose is to find Unused tables in the database.
In many forums it has been stated that columns like last_DDL_TIME in USER_OBJECTS is not accurate. Kindly suggest.
Thanks in advance.
Regards
Ravi
How to find list of tables with last access date ( Based on "select" statement).
The purpose is to find Unused tables in the database.
In many forums it has been stated that columns like last_DDL_TIME in USER_OBJECTS is not accurate. Kindly suggest.
Thanks in advance.
Regards
Ravi
0