> -----Original Message----- > Does it make sense to break the data into several > tables Pay no attention to that man behind the curtain! Here, this should make you feel better. (Yes folks, this is real.) 1* select table_name, max(column_id) from dba_tab_columns where owner = 'XXXXXX' group by table_name order by 2 desc SQL> / TABLE_NAME MAX(COLUMN_ID) ------------------------------ -------------- ARCHIVE_RAFILE 170 RAFILE 170 ARCHIVE_RESFIL 165 RESFIL 165 CUSFIL 102 IFDB_VEHICLE_VIEW 99 VEH_INVOICE 68 ARCHIVE_VEH_PHY_DATA 47 VEH_PHY_DATA 47 PROFILE 44 LICRAF 42 ARCHIVE_DEPPAY 41 etc etc etc ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------