| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:RE: Another simple question
Dennis,
Allow me to add another item to the pile from the OLD days. Back in SQL*Net V1 it was recommended to select a database name/SID that was "case insensitive". That restriction/recommendation was due to older DOS based clients that handled all of that sort of data as upper case. Therefore a database/SID name of 'Prod' would translate on some DOS/MPE based systems to 'PROD' as it passed through the OS/network layers. The result was that you could not connect to the database.
Dick Goulet
____________________Reply Separator____________________ Author: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> Date: 1/24/2003 7:39 AM
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).
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:
INET: dgoulet_at_vicr.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 - 11:04:31 CST
 |
 |