Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with some PDBs after enabling Extended Data Types

873970Oct 20 2016 — edited Feb 16 2017

When I enabled Extended Data Types on my multi tenant  test database i have faced with problem some of pdbs successfully upgraded and opened but some pdbs not.

now i can't open them, it error like bellow. If someone now how to disable  Extended Data Types or have solution for this problem please help.

SQL> show pdbs

    CON_ID CON_NAME  OPEN MODE  RESTRICTED

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

  2 PDB$SEED  READ ONLY  NO

  3 DB1  READ WRITE NO

  4 DB2  MOUNTED

  5 DB3  READ WRITE NO

  6 DB4  READ WRITE NO

  7 DB5  READ WRITE NO

  8 DB6  MOUNTED

SQL> alter session set container=DB2;

Session altered.

SQL> startup;

ORA-14696: MAX_STRING_SIZE migration is incomplete for pluggable database DB2

SQL> alter session set container=DB6;

Session altered.

SQL> alter pluggable database open;

alter pluggable database open

*

ERROR at line 1:

ORA-14696: MAX_STRING_SIZE migration is incomplete for pluggable database DB6

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 16 2017
Added on Oct 20 2016
8 comments
3,088 views