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!

Query to find the all the tables which are never used in the database

$phinx19Dec 8 2014 — edited Dec 10 2014

OS: RHEL

DB: 11G

Hi All,

We are planning to cleanup the database by removing all the tables which are never used and no longer required in the database post their creation, such as backup tables. Could you please provide me a query to find these tables as I have to send the details to the app to drop the same.

Regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 7 2015

Added on Dec 8 2014

#general-database-discussions

19 comments

4,085 views