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

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle 816 sid name limit:

Re: oracle 816 sid name limit:

From: Howard J. Rogers <howardjr_at_www.com>
Date: 2000/09/21
Message-ID: <39c9dbc4$1@news.iprimus.com.au>#1/1

The 4 character limitation was only ever an NT thing. And yes, it caused no end of grief when it came to descriptive names!!

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------



"Dave A" <dave_and_vanna_at_hotmail.com> wrote in message
news:ssilekiglr3q59_at_corp.supernews.com...

> We have 8 character SIDs with 7.3.4 on Solaris. Wasn't aware there was
ever
> a 4 character limitation. Wow, that would be a limitation...I thought 8
was
> bad. So much for descriptive names.
>
> --
> Dave A
>
>
> "Howard J. Rogers" <howardjr_at_www.com> wrote in message
> news:39c9443c$1_at_news.iprimus.com.au...
> > Changed in 8.1.5. It's an Oracle thing, not an NT one.
> >
> > Regards
> > HJR
> > --
>
> --------------------------------------------------------------------------
> > Opinions expressed are my own, and not those of Oracle Corporation
> > Oracle DBA Resources:
http://www.geocities.com/howardjr2000
>
> --------------------------------------------------------------------------
> >
> >
> >
> > "david spaisman" <david.spaisman_at_compaq.com> wrote in message
> > news:8qanq5$656$1_at_mailint03.im.hou.compaq.com...
> > > Hello:
> > >
> > > When I was using Oracle 804 on NT Ii thought there was a limit on the
> > > number of characters that a SID could be named-- that was 4
characters as I
> > > had once received an error to that effect.
> > >
> > > In Oracle 816, has the maximum number of characters changed to 8
charcters
> > > for the SID name or has the maximum been 8 characters for a while? If
the
> > > later, from what version on NT?
> > >
> > > Any information that can be provided will be appreciated. THanks.
> > >
> > > David Spaisman
> > >
> > >
> > >
> > >
> >
> >
>
>
Received on Thu Sep 21 2000 - 00:00:00 CDT

Original text of this message

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