Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Why DB_Name 4 chars only.

Re: Why DB_Name 4 chars only.

From: Rodd Holman <roddholman_at_HotPOP.com>
Date: Tue, 30 Jul 2002 12:31:33 -0800
Message-ID: <F001.004A6790.20020730123133@fatcity.com>


You can go to 8. We use up to 8 character SID's here. I have tried going 9 on an 8.0.5
system and it barfed on the create scripts.

Rodd

On Tue, 2002-07-30 at 15:08, Srinivas wrote:

    Hi,
    What is the reason behind DB_Name/SID usually 4 chars     length only. I have a customer who is asking us to     create instance/db with 6 chars length. We usually     keep instance name and db_name parameters same in .ora     file. Can someone please explain the reason behind     db_name 4 chars only. Is it a common practice to keep     SID/db_name/instance name parameters same (for example     PBDS).          thanks
    Srinivas          



    Do You Yahoo!?
    Yahoo! Health - Feel better, live better     http://health.yahoo.com
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com     --
    Author: Srinivas
      INET: zirraffeee_at_yahoo.com     
    Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
    San Diego, California        -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    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.com
--

Author: Rodd Holman
  INET: roddholman_at_HotPOP.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Tue Jul 30 2002 - 15:31:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US