Re: 30 Character Limit

Hi!

It's actually 30 *byte* limit, since the name column is varchar2(30), so if you use a multibyte characterset like UTF8 and start using öäõüsz etc. chars in your table names, you might end up with even less characters. So, dont use special chars in your object names..

SQL> desc obj$

 Name                                      Null?    Type
 ----------------------------------------- -------- ------------------------
----
 OBJ#                                      NOT NULL NUMBER
 DATAOBJ#                                           NUMBER
 OWNER#                                    NOT NULL NUMBER
 NAME                                      NOT NULL VARCHAR2(30)

Tanel.

"Harish" <harishparam_at_yahoo.com> wrote in message news:26f800fb.0302170400.2be608df_at_posting.google.com...
> Hi,
>
>
> My Apologies if the question sounds a bit silly. I need to know the
> following
>
> 1. Oracle imposes 30 character limit on object names. Any specific
> reasons why this limit has not been relaxed even in 9i.
>
> 2. SMON only coalesces contingous free extents when the pctincrease is
> set to non-zero value.
> What is the reason for this ?
>
> TIA,
>
> Hari
Received on Mon Feb 17 2003 - 09:32:41 CST