Re: Max length name of a database/schema

Kenneth Koenraadt wrote in message news:<4182582f.742468_at_news.inet.tele.dk>...
> On Fri, 29 Oct 2004 14:40:44 GMT, HansF <news.hans_at_telus.net> wrote:
>
> >Fred BROUARD - SQLpro wrote:
> >
> >>
> >>
> >> Did you know what is the maximum character length for a name of a database
> >> or schema ?
> >>
> >
> >Yes.
> >
> ><answering the implied question as well>
> >All identifiers in Oracle are 30 characters. I note you have SQL Server
> >background - one common trap for those wiith your background: [per
> >standard?] Oracle upper cases all unquoted identifiers. Once you start
> >using quoted identifiers you need to use the double-quotes for ever.
> ></answer>
> >
> >BTW, that info is found in the SQL Language refece manual at
> >http://docs.oracle.com
> >
> >/Hans
>
> The database name can only be 8 bytes long, as stated in the SQL
> reference.
>
> - Kenneth Koenraadt

I believe Hans was noting the "database or schema" and postulating the OP was using them interchangeably. This is common among those coming from some other database engine backgrounds than Oracle.

Fred: Be sure you understand that what other db's call a database, Oracle calls a schema or user. The Oracle definition of database is more all-encompassing. Study the concepts manual.

Hans: Great typo (if it was) in the manual name! :)

jg

--
@home.com is bogus.  "A database is a repository. Its just sits there.
Quiet and dumb.  It's that MS (management system) part that does all
the work. To the
best of my knowledge neither Oracle nor IBM are in the business of
selling databases."  - Serge Rielau