Posted By

thescorpion on 10/12/12


Tagged

sql Oracle PLSQL DBA


Versions (?)

Mostrar Objetos que hacen Referencia a un Objeto Especifico


 / Published in: SQL
 

Mostrar Objetos que hacen Referencia a un Objeto Especifico en Oracle

  1. SELECT OWNER,
  2. Type,
  3. Name,
  4. REFERENCED_OWNER,
  5. REFERENCED_TYPE,
  6. REFERENCED_NAME
  7. FROM DBA_DEPENDENCIES
  8. WHERE ((OWNER LIKE UPPER('&1') AND Name LIKE UPPER('&2')) OR
  9. (REFERENCED_OWNER LIKE UPPER('&1') AND
  10. REFERENCED_NAME LIKE UPPER('&2')))
  11. AND REFERENCED_OWNER != 'SYS'
  12. AND REFERENCED_TYPE != 'NON-EXISTENT'
  13. ORDER BY OWNER, Type, Name;

Report this snippet  

You need to login to post a comment.