RE: Large databases

Well ... you just make sure they are very W-I-D-E columns and use the substring function a lot.

-----Original Message-----
Sent: Wednesday, April 16, 2003 12:24 PM To: Multiple recipients of list ORACLE-L

Jeremy,

Are you serious?
Where did you get this limitation (4 columns per table) for transactional (btw. did you mean OLTP?) systems?
Are you ready to substantiate your statement?

Igor Neyman, OCP DBA
ineyman_at_perceptron.com   

• Original Message ----- To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 16, 2003 1:03 PM

> From: Lyndon Tiu [mailto:ltiu_at_alumni.sfu.ca]
>
> Ths is real and happened to me last month.
>
> An "Access DBA" told me after seeing my Oracle/Postgresql database ER
> Diagram:
>
> "Your database is too big. I took an Access course last year
> and the instructor mentioned that tables should have no more
> than 4 columns each."

Would it be cruel of me to point out that s/he has a point? Assuming you're talking about a transactional system, of course...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: Stephen.Lee_at_DTAG.Com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).