User Tools

Site Tools


kurs:unterschiedliche_objecte_mit_abhaengigkeiten_in_datenbanken_finden
select object_name, object_type from user_objects@orclc41203 
minus
select object_name, object_type from user_objects

select dbms_metadata.get_ddl('TABLE','EMPLOYEES') from dual

select referenced_name, dbms_metadata.get_ddl(referenced_type, referenced_name) from (
  select name, type, referenced_name, referenced_type from 
    user_dependencies where name='CHANGE_EMP' and type='PACKAGE BODY'
    minus 
  select name, type, referenced_name, referenced_type from user_dependencies@orclc41202
) where referenced_name not in ('STANDARD', 'DBMS_OUTPUT', 'DUAL')
and    referenced_name not in (select object_name from user_objects@orclc41202)
kurs/unterschiedliche_objecte_mit_abhaengigkeiten_in_datenbanken_finden.txt · Last modified: 2014/09/10 21:22 (external edit)