2 Replies Latest reply on Aug 19, 2015 4:12 PM by steveabraham

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

    steveabraham

      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?