kurs:unterschiedliche_objecte_mit_abhaengigkeiten_in_datenbanken_finden
Differences
This shows you the differences between two versions of the page.
| — |
kurs:unterschiedliche_objecte_mit_abhaengigkeiten_in_datenbanken_finden [2014/09/10 21:22] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | <code> | ||
| + | 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) | ||
| + | |||
| + | </code> | ||
kurs/unterschiedliche_objecte_mit_abhaengigkeiten_in_datenbanken_finden.txt ยท Last modified: 2014/09/10 21:22 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
