Showing posts with label Dependent object list in Oracle. Show all posts
Showing posts with label Dependent object list in Oracle. Show all posts

Friday, November 13, 2009

Oracle Dependency Tree

SELECT LPAD(' ', (A.NIVEL - 1) * 2) || OBJ.NAME A,
LPAD(' ', (A.NIVEL - 1) * 2) || CONS.NAME B
FROM SYS.OBJ$ OBJ,
SYS.CON$ CONS,
(SELECT OBJ# OBJ#, CON#, LEVEL NIVEL
FROM SYS.CDEF$
WHERE RCON# IS NOT NULL AND ROBJ# IS NOT NULL
CONNECT BY ROBJ# = PRIOR OBJ# AND ROBJ# != OBJ# AND
PRIOR ROBJ# != PRIOR OBJ#
START WITH ROBJ# = (SELECT OBJ#
FROM SYS.OBJ$
WHERE NAME = UPPER('fnd_concurrent_requests') AND TYPE# = 2 AND
OWNER# = USERENV('SCHEMAID'))) A
WHERE CONS.CON# = A.CON# AND OBJ.OBJ# = A.OBJ# AND OBJ.TYPE# = 2
UNION ALL
SELECT LPAD(' ', (A.NIVEL - 1) * 2) || OBJ.NAME A, TO_CHAR(NULL)
FROM SYS.OBJ$ OBJ,
(SELECT D_OBJ# OBJ#, LEVEL NIVEL
FROM SYS.DEPENDENCY$
CONNECT BY P_OBJ# = PRIOR D_OBJ#
START WITH P_OBJ# = (SELECT OBJ#
FROM SYS.OBJ$
WHERE NAME = UPPER('fnd_concurrent_requests') AND
OWNER# = USERENV('SCHEMAID'))) A
WHERE OBJ.OBJ# = A.OBJ# AND OBJ.TYPE# != 2

Troubleshooting ACFS-07981: Metadata Validation Errors

  Troubleshooting ACFS-07981: Metadata Validation Errors Introduction The ACFS-07981 error indicates that an attempt to run an online file ...