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 <[EMAIL PROTECTED]>
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.
[EMAIL PROTECTED]
-----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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
