| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database Design questions
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_at_hypercom.com
"To really screw up Linux you have to work at it...To really screw up Windows, you have to work ON
it..."
Stephen.Lee_at_DTAG.Com
Sent by:
oracle-l-bounce_at_freelists.o To
rg oracle-l_at_freelists.org
cc
06/18/04 11:40 AM Subject
RE: Database Design questions
Please respond to
oracle-l_at_freelists.org
> -----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 41etc
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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_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 - 15:49:23 CDT
 |
 |