Configuration of Extended Data Type Capability (extended string)

SQL> sho parameter max_string_size
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
max_string_size                      string      STANDARD
 
 
 
## First take the database out from the RAC (cluster) mode
 
CONNNECT SYS / AS SYSDBA
 
SHUTDOWN IMMEDIATE;
STARTUP UPGRADE;
ALTER SYSTEM SET max_string_size=extended;
START $ORACLE_HOME/rdbms/admin/utl32k.sql
SHUTDOWN IMMEDIATE;
STARTUP;
 
 
SQL> show parameter max_string_size
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
max_string_size                      string      EXTENDED