RE: Database Design questions
- From: Ron Thomas <rthomas@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 18 Jun 2004 13:48:06 -0700
You obviously have never worked with Oracle Apps...
SQL> select * from
( select table_name, max(column_id)
from dba_tab_columns
where owner != 'APPS' -- apps only has views, packages, etc
group by table_name order by 2 desc )
where rownum < 20
/
TABLE_NAME MAX(COLUMN_ID)
------------------------------ --------------
EDWCMPALLCLASSES 729
IGF_AP_CSS_INTERFACE_ALL 689
ECE_STAGE 519
EDW_ITEMS_M 494
IGF_AP_ISIR_INTRFACE_ALL 470
OE_LINE_ACKS 415
OE_LINES_IFACE_ALL 411
AMS_LIST_ENTRIES 389
IGF_AP_CSS_FNAR_ALL 371
ICX_POR_UPLOAD_IT_DUMP 343
RLM_INTERFACE_LINES_ALL 337
IGF_AP_CSS_PROFILE_ALL 328
QRM_SAVED_ANALYSES_ROW 327
AS_IMPORT_INTERFACE 326
MTL_SYSTEM_ITEMS_INTERFACE 326
OE_ORDER_LINES_HISTORY 324
ECE_PO_INTERFACE_HEADERS 312
OE_ORDER_LINES_ALL 312
RLM_SCHEDULE_LINES_ALL 312
19 rows selected.
Ron Thomas
Hypercom, Inc
rthomas@xxxxxxxxxxxx
"To really screw up Linux you have to work at it...To really screw up Windows,
you have to work ON
it..."
Stephen.Lee@xxxxxxxx
Sent by:
oracle-l-bounce@xxxxxxxxxxx
To
rg oracle-l@xxxxxxxxxxxxx
cc
06/18/04 11:40 AM
Subject
RE: Database Design questions
Please respond to
oracle-l@xxxxxxxxxxxxx
> -----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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
