Database Administration (MOSC)

MOSC Banner

Problem with some PDBs after enabling Extended Data Types

edited Apr 1, 2018 4:15PM in Database Administration (MOSC) 11 commentsAnswered

When I enabled Extended Data Types on my multi tenant  test database 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  MOUNTEDSQL> alter session set container=DB2;Session altered.SQL> startup;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center