RE: Another simple question

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Fri, 24 Jan 2003 07:39:54 -0800
Message-ID: <F001.00539B19.20030124073954@fatcity.com>

Banarasi - Worse than that, Oracle used to recommend that you use no more than 4 characters (look at your process names, and imagine if your O.S. only allowed 8 characters for the name). The problem is that some, mostly older, computer systems have severe filesystem and process name limitations. I know that it is hard for you young whipper-snappers ;-) to believe, but back in the olden days, a byte was expensive. Oracle built its empire by running well on everybody's system. So this restriction allowed/allows Oracle to run on some pretty archaic systems.

   Will it ever be changed? I wouldn't bet on it. Think about how many separate parts of Oracle would have to be changed. And where is the ROI for this change?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, January 23, 2003 10:44 PM To: Multiple recipients of list ORACLE-L

Hi All

Why name of the Database is restricted to 8 bytes. where as we can have long names for tablespaces, tables, views, etc ?

thanks
Banarasi Babu
--

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

Author: BanarasiBabu Tippa
  INET: btippa_at_ORsoftware-india.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).
--

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

Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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). Received on Fri Jan 24 2003 - 09:39:54 CST