Question on larger than 30 char entity in 12c

From: Hanan Hit <hithanan_at_gmail.com>
Date: Sat, 17 May 2014 07:17:49 -0700
Message-Id: <3E5225F7-EB35-402D-8B63-63B9E414AA7E_at_gmail.com>

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 Sat May 17 2014 - 16:17:49 CEST