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).
