Noncdb_to_pdb.sql Script Taking Too Long To Run (Doc ID 2814341.1)

Last updated on APRIL 17, 2023

Applies to:

Goal

Executing the script "noncdb_to_pdb.sql", the session is running for hours and its stuck on the following query.

SELECT NULL FROM SYS.OBJ$ O, SYS.COLTYPE$ T WHERE BITAND(T.FLAGS, 256) = 256 AND
 T.OBJ# = O.OBJ# AND O.OWNER# NOT IN (SELECT USER# FROM SYS.USER$ WHERE TYPE#=1
AND BITAND(SPARE1, 256)= 256) AND T.OBJ# IN (SELECT DISTINCT D_OBJ# FROM SYS.DEPENDENCY$
START WITH P_OBJ# IN (SELECT OBJ# FROM SYS.OBJ$ WHERE TYPE#=13 AND BITAND(FLAGS, 4194304) =
4194304) CONNECT BY PRIOR D_OBJ# = P_OBJ#) AND ROWNUM <=1;
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.