User Tools

Site Tools



This shows you the differences between two versions of the page.

Link to this comparison view

kurs:unterschiedliche_objecte_mit_abhaengigkeiten_in_datenbanken_finden [2014/09/10 21:22] (current)
Line 1: Line 1:
 +select object_name,​ object_type from user_objects@orclc41203 ​
 +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)