My Oracle Support Banner

ORA-01405 while running "noncdb_to_pdb.sql" (Doc ID 2000882.1)

Last updated on AUGUST 04, 2018

Applies to:

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

Symptoms

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.

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.