INCREASE MAX STRING SIZE OF VARCHAR2 FROM 4000 BYTE TO 32768 BYTE

https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/MAX_STRING_SIZE.html#GUID-D424D23B-0933-425F-BC69-9C0E6724693C

  1. Shut down the database.
    shutdown immediate;
  2. Restart the database in UPGRADE mode.
    startup upgrade;
  3. Change the setting of MAX_STRING_SIZE to EXTENDED.
    ALTER SYSTEM SET max_string_size=extended SCOPE=SPFILE;
  4. Run the rdbms/admin/utl32k.sql script. You must be connected AS SYSDBA to run the script.
    @/app/oracle19c/product/19.3/db/rdbms/admin/utl32k.sql;
  5. Restart the database in NORMAL mode.
    shutdown immediate;
    startup;
  6. Run the rdbms/admin/utlrp.sql script to recompile invalid objects. You must be connected AS SYSDBA to run the script.
    @/app/oracle19c/product/19.3/db/rdbms/admin/utlrp.sql;

Leave a Reply

Your email address will not be published. Required fields are marked *