Que Objetos Urilizan la misma tabla
SQL>select owner, name, type from all_dependencies where referenced_owner = 'NOM_ESQUEMA' and referenced_name = 'NOM_TABLA';
Que tablas o vistas usa un objeto PL/SQL
SQL>select referenced_owner, referenced_name, referenced_type from all_dependencies where owner = 'NOM_ESQUEMA' and name = 'NOM_PAQUETE' and referenced_type in( 'TABLE' , 'VIEW') order by 1,2;
Re-compilar Paquetes
ALTER PACKAGE emp_mgmt COMPILE DEBUG PACKAGE;
ALTER PACKAGE emp_mgmt COMPILE DEBUG SPECIFICATION;
ALTER PACKAGE emp_mgmt COMPILE DEBUG BODY;
Detectar objetos inválidos en Bases de Datos
select * from dba_objects where STATUS='INVALID' AND OWNER = 'OWNER';
select object_name from dba_objects where STATUS='INVALID' AND OWNER = 'OWNER';
select object_name,STATUS from dba_objects where object_name like '%PKG%' AND STATUS='INVALID' AND OWNER = 'OWNER';