Oracle-L: RE: RE: Manager decrees "his" data warehouse design. Help!

From: Bellows, Bambi <BBellows_at_usg.com>
Date: Wed, 27 Feb 2002 12:08:21 -0800
Message-ID: <F001.0041A2AF.20020227120821@fatcity.com>

Also not uncommon when tracking medical data.

Bambi.

-----Original Message-----
Sent: Wednesday, February 27, 2002 1:53 PM To: Multiple recipients of list ORACLE-L

Some of the tables in J.D. Edwards OneWorld have over 200 columns, VARCHAR is not used, only NUMBER and CHAR. Makes for some wide tables. This product was originally some type of flat file database.

Ethan

-----Original Message-----
Sent: Wednesday, February 27, 2002 1:28 PM To: Multiple recipients of list ORACLE-L

I think the column limit is now closer to 1000, but like you, I can't imagine
willingly designing a table with a column count exceeding 2 digits.

More than 15 or 20 and I start to question the design.

Jared

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Post, Ethan
INET: Ethan.Post_at_ps.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Bellows, Bambi
INET: BBellows_at_usg.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------