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!

ORA-01405: fetched column value is NULL - Migrate noncontainer database to pluggable

steveabrahamJul 17 2015 — edited Aug 19 2015

I upgraded a 11.2.0.4 db to 12c database and tried to migrate it to container database in other database. I used the xml file from DBMS_PDB.DESCRIBE from non container db and I successfully plugged in the database but when I tried to run noncdb_to_pdb.sql, its failing with below error

SQL> alter pluggable database "&pdbname" open upgrade;

old 1: alter pluggable database "&pdbname" open upgrade

new 1: alter pluggable database "DSWPD02" open upgrade

alter pluggable database "DSWPD02" open upgrade

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

ORA-01405: fetched column value is NULL

from alert its showing

ALTER SYSTEM: Flushing buffer cache inst=0 container=4 local

ORA-604 signalled during: alter pluggable database DSWPD02 open restricted...

Can you please help me to identify and rectify the issue?

This post has been answered by Emad Al-Mousa on Jul 17 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 16 2015

Added on Jul 17 2015

#database-key-features, #multitenant

2 comments

6,439 views