Oracle-L: RE: char vs. varchar in a data warehouse

From: Jon Baker <jcb_at_netsec.net>
Date: Wed, 05 Jun 2002 08:28:33 -0800
Message-ID: <F001.004751DE.20020605082833@fatcity.com>

Makes no sense at all. The 'developers' don't want to deal with the space when manipulating that value? If it ain't there, they do nothing.

All of the space management will be up to you, not the developers.

Jon

-----Original Message-----
Sent: Wednesday, June 05, 2002 11:53 AM
To: Multiple recipients of list ORACLE-L

Hi -

We are in the process of building a data warehouse and data stores. This will be built on a Sun Solaris (2.8) machine running Oracle 9i R1. Estimates are approximately 180GB.

The developers have defined most of their small character fields as varchar2 - even the ones of size 1! They tell me that if the column does not have a value, they do not want to have to deal with a 'space' when manipulating that value.

Does this make sense? Should I be pursuing this further or shouldn't I care as the DBA?

Lisa

--

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

Author: YTTRI Lisa
INET: lisa.yttri_at_cnh.com

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: Jon Baker
INET: jcb_at_netsec.net

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