RE: Database Design questions

  • From: Stephen.Lee@xxxxxxxx
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 18 Jun 2004 13:40:46 -0500

> -----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
-----------------------------------------------------------------

Other related posts: