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: Max length of SID in Oracle 8

RE: Max length of SID in Oracle 8

From: <jkstill_at_cybcon.com>
Date: Thu, 18 Jan 2001 08:36:52 -0800 (PST)
Message-Id: <10745.127015@fatcity.com>


Hmmm...

We have at least two databases with 8 character SID's.

Oracle has always recommended that SID's be 4 characters, but the maximum length has been 8 for some years.

Could be that the docs are wrong.

Wouldn't be the first time. :)

Jared

On Wed, 17 Jan 2001, Cale, Rick T (Richard) wrote:

> I found it in the "Getting Started" book. Max length is still 4.
>
> Rick
>
> > -----Original Message-----
> > From: Cale, Rick T (Richard) [SMTP:RICHARD.T.CALE_at_saic.com]
> > Sent: Wednesday, January 17, 2001 2:34 PM
> > To: ORACLE-L_at_fatcity.com; oracledba_at_quickdoc.co.uk
> > Subject: Max length of SID in Oracle 8
> >
> > Hi DBAs,
> >
> > I cannot seem to find what the max length of SID is. Is it still 4? I was
> > thinking in one of the newer version
> > it increased in size.
> >
> > Thanks
> > Rick Cale, Science Applications International Corp.
> > Phone:865-481-2198, fax:865-481-8555
> > e-mail: caler_at_saic.com
> >
> >
> > --------
> > Think you know someone who can answer the above question? Forward it to
> > them!
> > to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> > to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Cale, Rick T (Richard)
> INET: RICHARD.T.CALE_at_saic.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 Thu Jan 18 2001 - 10:36:52 CST

Original text of this message

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