After recovery ORA-14693 / ORA-14694

(Doc ID 2011194.1)

Last updated on APRIL 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 12.1]
Information in this document applies to any platform.


SQL>  alter pluggable database all open;

ORA-14693: The MAX_STRING_SIZE parameter must be EXTENDED.

SQL> show pdbs

   CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB11                          MOUNTED     NO             <<<<<<<<<<<<<<<<<<<<<<  This database is not opened
         4 PDB12                          READ WRITE NO
         5 PDB13                          READ WRITE NO

SQL> alter pluggable database PDB11 open;
alter pluggable database PDB11 open
ERROR at line 1:
ORA-14693: The MAX_STRING_SIZE parameter must be EXTENDED.


SQL> sho parameter max_string_size



------------------------------------ ----------- ------------------------------

max_string_size string STANDARD             <<<<<<<<<< in CDB$ROOT


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms