Re: Question on larger than 30 char entity in 12c
- From: Phillip Jones <phil@xxxxxxxxxx>
- To: hithanan@xxxxxxxxx
- Date: Sun, 18 May 2014 01:20:15 +0100
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@xxxxxxxxx> 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
>
>
Other related posts:
