Is there a sql command that could tell me if a table is emtpy or not in use ? Thanks
If your tables are analyzed regularly, you can query dba_tables for num_rows = 0.
Jeff Hunter
Forum Rules