RE: Database Design questions

From: <Stephen.Lee_at_DTAG.Com>
Date: Fri, 18 Jun 2004 13:40:46 -0500
Message-ID: <D6339830FC73944E889CC3CEADDB205B07909478@bu-dtagpo1.tracs.com>

> -----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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Jun 18 2004 - 13:37:50 CDT