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 > >