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

  • From: Hanan Hit <hithanan@xxxxxxxxx>
  • To: Phillip Jones <phil@xxxxxxxxxx>
  • Date: Sat, 17 May 2014 17:28:48 -0700

Hi Phil, 

Got it.

Thanks for the prompt response. 

Regards,
        Hanan

On May 17, 2014, at 5:20 PM, Phillip Jones <phil@xxxxxxxxxx> 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@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: