Re: Object Name 30 Char Max Limit??

From: Daniel Fink <Daniel.Fink_at_Sun.COM>
Date: Wed, 21 Jul 2004 13:25:55 -0600
Message-id: <40FEC343.D65900F8@sun.com>

Yes. The name of a user is constrained by the storage of the name in the data dictionary. Anything that is stored in the data dictionary is constrained by the definition of the column in the table that correlates to the field.
SQL> desc sys.user$
 Name
Null? Type

---

• --------------------- USER# NOT NULL NUMBER NAME NOT NULL VARCHAR2(30) ...

"bernas, glen" wrote:

> Is 30 Characters the max length of a User/Schema name??
>
> Database Version: 9.2.0.4.0
>
> ____________________________________________
>
> Glen Bernas
> Database Administrator
> EMC=B2 =09
> where information lives
>
> Phone:=20
> Direct: (508) 249-2237
> Ext: 42237
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Jul 21 2004 - 14:22:46 CDT