Re: Max length name of a database/schema

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