Re: Varchar2....is this Dilbert or what?????

From: Robert Jenkins <rojenkin_at_district.vannet.k12.wa.us>
Date: Tue, 09 May 2000 14:38:24 -0700
Message-Id: <10492.105284@fatcity.com>

Wow, your head honcho is a cartoon character. An ignorant one at that. But you can be diplomatic and tell them that increasing a varchar2 column is no problem. But decreasing will cause data corruption. No that won't = work
cuz then they'll just want to make everything varchar2(4000). If the person doing the database design can't convince them that a flag = column
should be varchar2(1) then find a different designer. By the way I have a = Muave database
your head honcho might be interested in.

>>> Christine Turner <christine.turner_at_ips-sendero.com> 5/9/00 3:04:15 PM =
>>>

Ok, forgive me if I offend anyone....but the head honchos came and = asked=20
what the ramifications would be if we were to make every, yes EVERY=20 varchar2 column in new database the length of 255. The reasoning = behind=20
this is...."to keep maintenace down in the future, so we don't have to=20 change the database every time when need a column resized". I'm fairly = new=20
to being a database administrator (going on a year), but I have been=20 working in Oracle for about 6 years and quite frankly this sounds = totally=20
obsurd! Anyone have any comments??? Pro's, Con's????

Thanks In Advance,
Christine Turner
FTP Database Administrator
IPS Sendero
Phone: (800) 321-6899 ext. 3286
Fax: (480) 946-8224
E-mail: christine.turner_at_ips-sendero.com=20

--=20
Author: Christine Turner
  INET: christine.turner_at_ips-sendero.com=20

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). Received on Tue May 09 2000 - 16:38:24 CDT