User following SQL to find the dependencies of an object/ta ble.
SELECT
*
FROM
sys.dba_dependencies
WHERE
1 =1
-- AND referenced_type = 'TABLE'
AND referenced_owner = 'APPS'
AND UPPER(referenced_name) IN UPPER('XXINV_ITEMS_OUTBOUND_STG');
SELECT
*
FROM
sys.dba_dependencies
WHERE
1 =1
-- AND referenced_type = 'TABLE'
AND referenced_owner = 'APPS'
AND UPPER(referenced_name) IN UPPER('XXINV_ITEMS_OUTBOUND_STG');
2 comments:
Hi,
this blog was an excellent contribution to the oracle community, I think are basic but very useful things, I congratulate you and the reason to keep going.
Oracle Financials training
Thank you.
Post a Comment