Re: Question on larger than 30 char entity in 12c

From: Hanan Hit <hithanan_at_gmail.com>
Date: Sat, 17 May 2014 17:28:48 -0700
Message-Id: <2DD321ED-DA2D-4561-B751-4E55100E918F_at_gmail.com>



Hi Phil,

Got it.

Thanks for the prompt response.

Regards,

        Hanan

On May 17, 2014, at 5:20 PM, Phillip Jones <phil_at_phillip.im> wrote:

> Hello,
>
> Just because the size of a given datatype has increased does not mean that every single column of that datatype is going to increase to that limit.
>
> For object names the limit is still 30 bytes, or 128 bytes for database links, as documented: http://docs.oracle.com/cd/E16655_01/server.121/e17209/sql_elements008.htm#SQLRF00223
>
> Cheers,
>
> Phil
>
>
>
>
> On Sat, May 17, 2014 at 3:17 PM, Hanan Hit <hithanan_at_gmail.com> wrote:
> Hi List,
>
> I am working with 12c and was able to use the new large data type for VARCHAR2 etc.
> I am now using a VARCHAR2(32767) and NVARCHAR2(16383)
>
>
> Now I noticed at the Data Dict that tables and other entities are defined as
>
> SQL> desc user_tables
> Name Null? Type
> ----------------------------------------- -------- ----------------------------
> TABLE_NAME NOT NULL VARCHAR2(128)
>
>
> But I am unable to create a table with large than 30 char (old restrictions).
>
> Do anyone know if this is doable (I recall reading that in some Oracle Doc ) or do I need to turn another init.ora parameter?
>
> Any help would be highly appreciated.
>
> Best,
> Hanan
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Sun May 18 2014 - 02:28:48 CEST

Original text of this message