The datatypes of varchar2, NVARCHAR2 has increased from 4000 bytes to 32767 bytes in 12c.
After the upgrade if you try to create a table with the new size you can’t do that directly:
create table mousaem.tab1 (id number,text varchar2(32767 byte));
You will receive the below error:
To enable this feature:
1.You first need to make sure that the parameter “COMPATIBLE=12.1.0” is added to your init.ora file. usually the initialization parameter file is located under Oracle Home then dbs file system in (unix/linux) environments.
2. Then, add the following parameter in your init.ora file
3.Then you need to shut down the database
4.Then startup in “upgrade” mode
5.Then execute the script:
6.Then shutdown the database normally
SQL> shutdown immediate
7.Then “startup” normally and check the parameter
Now Try re-creating the table again ………. created successfully!!!!!
you can double check it from TOAD or Sql developer:
Interesting New Feature 😉