Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 30 Character Limit on Oracle
Why do you want an object name longer than 30 chars?
-- Best of Breed Oracle Tools * ER Diagramming Tool - DBArtisan by http://www.embarcadero.com * PL/SQL Editor - SQL Navigator by http://www.quest.com * Database Monitoring - DBFlash for Oracle by http://www.confio.com * SQL Tuning/Optimization - DB Expert by http://www.leccotech.com "Harish" <harishparam_at_yahoo.com> wrote in message news:26f800fb.0302170401.23f180ef_at_posting.google.com...Received on Tue Feb 18 2003 - 13:42:03 CST
> 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