Increasing the Maximum Size of VARCHAR2, NVARCHAR2, and RAW Columns in an Oracle RAC Database?
In document of Oracle, it explained
To increase the maximum size ofVARCHAR2
,NVARCHAR2
, andRAW
columns in an Oracle RAC database: Shut down all of the Oracle RAC database instances, except one. Restart the Oracle RAC database instance inUPGRADE
mode. Change the setting ofMAX_STRING_SIZE
toEXTENDED
. Run therdbms/admin/utl32k.sql
script in the Oracle RAC database instance. You must be connectedAS SYSDBA
to run the script. Restart all Oracle RAC database instances inNORMAL
mode. Run therdbms/admin/utlrp.sql
script to recompile invalid objects. You must be connectedAS SYSDBA
1