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

But its only when you go to Plaid that you experience real speed...

--Scott

-----Original Message-----
From: Bill Noyes <WNoyes_at_delmarmedical.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Thursday, May 11, 2000 7:42 PM
Subject: RE: Varchar2....is this Dilbert or what?????

>Because Mauve has the most memory right? I loved that one!
>
>> -----Original Message-----
>> From: Robert Jenkins [SMTP:rojenkin_at_district.vannet.k12.wa.us]
>> Sent: Tuesday, May 09, 2000 3:48 PM
>> To: Multiple recipients of list ORACLE-L
>> Subject: Re: Varchar2....is this Dilbert or what?????
>>
>> 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
>> what the ramifications would be if we were to make every, yes EVERY
>> varchar2 column in new database the length of 255. The reasoning
>> behind
>> this is...."to keep maintenace down in the future, so we don't have to
>>
>> change the database every time when need a column resized". I'm
>> fairly new
>> to being a database administrator (going on a year), but I have been
>> working in Oracle for about 6 years and quite frankly this sounds
>> totally
>> 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
>>
>>
>> --
>> Author: Christine Turner
>> INET: christine.turner_at_ips-sendero.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).
>>
>> --
>> Author: Robert Jenkins
>> INET: rojenkin_at_district.vannet.k12.wa.us
>>
>> 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).
>--
>Author: Bill Noyes
> INET: WNoyes_at_delmarmedical.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
Received on Thu May 11 2000 - 21:30:59 CDT