My Oracle Support Banner

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

Last updated on FEBRUARY 02, 2022

Applies to:

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

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


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