8i | 9i | 10g | 11g | 12c | 13c | Misc | PL/SQL | SQL | RAC | Linux

Home » Misc » Here

Comments for Extended Data Types in Oracle Database 12c Release 1 (12.1)

Shadab Khan said...

On oracle 12c compatible, changed to extended with sysdba privileges.
I can create a table with varchar2(16000) as column now and insert a string > 4000 bytes; but only when connected as sysdba.
When connected as a normal user rather than sysdba, I cannot play with varchar2 >4000 bytes, an error ORA-60019 is thrown. Can you explain why?

Please reply to shadabzmail@gmail.com

Tim... said...


Have you done the correct setup for the type of database you are using? The article states there is a different procedure depending on the style of database you use, but it only gives one example. Make sure you have done the right thing.



Lasse Jenssen said...

Had to this to set MAX_STRING_SIZE:
> Sqlplus “/as sysdba”
SQL> alter system set max_string_size=EXTENDED scope=spfile;
SQL> shutdown immediate;
SQL> startup upgrade;
SQL> alter pluggable database all open upgrade;
SQL> @?/rdbms/admin/utl32k.sql
SQL> alter session set container=orcl;
SQL> @?/rdbms/admin/utl32k.sql
SQL> alter session set container=cdb$root;
SQL> shutdown immediate;

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!