ORA-01405 while running "noncdb_to_pdb.sql"

(Doc ID 2000882.1)

Last updated on OCTOBER 23, 2017

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


While running noncdb_to_pdb.sql,  You may get ORA-01405 error.

SQL> @noncdb_to_pdb.sql
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01405: fetched column value is NULL

The failing SQL will be similar to below:
select u.name, u.password, u.spare4, a.syspriv, decode(bitand(u.spare1, 128), 128, 1, 0) from adminauth$ a, user$ u where a.user# > 0 and u.user# = a.user# and a.syspriv != 0;

If any other SQL fails with ORA-01405,  then file a SR with Oracle Support as the cause may be different.   If the failing SQL is same as above, then proceed with the steps given in the "Solution" section.



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