Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

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.