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

Wow!

I wonder why no-one ever thought of this?

Let's see now...
The max is 2000 so it really should be Varchar2(2000) and while were at it lets find out the maxc disk space Oracle can access and buy that too. :-)

Only joking....
George

> -----Original Message-----
> From: "Christine Turner" <christine.turner_at_ips-sendero.com>
> [mailto:christine.turner_at_ips-sendero.com]
> Sent: Tuesday, May 09, 2000 11:04 PM
> To: smtp_at_inl001@servers["Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>]
> Subject: Varchar2....is this Dilbert or what?????
>
>
> 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).
Received on Wed May 10 2000 - 03:45:43 CDT