Limit tables to ones with rowcount > 0

Tim Deagan
2013-08-15
2013-08-15
  • Tim Deagan
    Tim Deagan
    2013-08-15

    I'm trying to run SchemaSpy (a critical tool in my toolbelt!!) on an Oracle PeopleSoft database. The schema as approximately 80,000 tables, only about 3,000 of which have any data in them. Getting SchemaSpy to run on the db at all has been rough (don't even try this with a 32-bit JRE!) but sussing out the relevant tables is a mess. There is no regex that will ID the tables of interest, but if I could select only tables with rowcount > 0, that would be a huge help. Is this somehow possible ('select table_name from all_tables where num_rows > 0' or somesuch?) Alternately, if I could feed a list of table names.

    Thanks, this tool is indispensible.