To increase the maximum size of VARCHAR2, NVARCHAR2, and RAW columns in a non-CDB:
-
Shut down the database.
-
Restart the database in
UPGRADE mode.
-
Change the setting of
MAX_STRING_SIZE to
EXTENDED.
-
Run the
rdbms/admin/utl32k.sql script.
You must be connected as
SYSDBA to run the script.
-
Restart the database in
NORMAL mode.
Note: The
utl32k.sql
script increases the maximum size of the VARCHAR2, NVARCHAR2, and RAW columns for the views where this is required. The script does not increase the maximum size of the VARCHAR2, NVARCHAR2, and RAW columns in some views because of the way the SQL for those views is written.
-
Run the
rdbms/admin/utlrp.sql
script to recompile invalid objects. You must be connected as SYSDBA to run the script.