'How to list all tables that have data in it?

I have around 2000 tables that most of them are not in use and do not have any data in them. I know how to list all tables as below

SELECT owner, table_name FROM ALL_TABLES

But I do not know how to list the one that has at least one row of data in it. Is there anyway to do that?

sqloracleplsql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions