Thank you very much Dennis and Dick for your info. wow!! These days I am learning lot. Thanks for my friend Ravi Kiran who suggested me to join this group..
-----Original Message----- Sent: Friday, January 24, 2003 10:35 PM To: Multiple recipients of list ORACLE-L 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). -- 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).