RE: Database Design questions

Steve,

I can easily beat these figures - using Oracle's own Apps 11i tables.. (btw - some of your 'tables' may actually be views - IFDB_VEHICLE_VIEW for eg.)

TABLE_NAME			MAX(COLUMN_ID)
----------			--------------
OE_LINE_ACKS		414
OE_LINES_IFACE_ALL	411
OE_LINES_INTERFACE	402
AMS_LIST_ENTRIES		380
ICX_POR_UPLOAD_IT_DUMP	343
ONT_PRT_ORDER_LINES_V	338
RLM_INTERFACE_LINES_ALL	335
RLM_INTERFACE_LINES	334
AS_IMPORT_INTERFACE	324
OE_ORDER_LINES_HISTORY	324
MTL_SYSTEM_ITEMS_INTERFACE	323
OE_ORDER_LINES_ALL	312
RLM_SCHEDULE_LINES_ALL	312
OE_ORDER_LINES		310

The top one - OE_LINE_ACKS - actually contains a _large_ number of attribute columns numbered from 1 through N where N reaches 15 in certain cases...

The advice still in this case is: Normalize where it makes sense.

>
>TABLE_NAME MAX(COLUMN_ID)
>------------------------------ --------------
>ARCHIVE_RAFILE 170
>RAFILE 170
>ARCHIVE_RESFIL 165
>RESFIL 165
>CUSFIL 102
>IFDB_VEHICLE_VIEW 99
>VEH_INVOICE 68
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

Disappointment is inevitable, but Discouragement is optional!

• The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

  ---

  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

  ---