Linker IT Software
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
all_dependencies (Read 3803 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
09.06.11 at 10:03:14
All_dependencies is an Oracle system view that lists dependencies between Oracle database objects.
Name                 Type          Nullable Default Comments                                                    
-------------------- ------------- -------- ------- ----------------------------------------------------------  
OWNER                VARCHAR2(30)                   Owner of the object                                        
NAME                 VARCHAR2(30)                   Name of the object                                          
TYPE                 VARCHAR2(17)  Y                Type of the object                                          
REFERENCED_OWNER     VARCHAR2(30)  Y                Owner of referenced object (remote owner if remote object)  
REFERENCED_NAME      VARCHAR2(64)  Y                Name of referenced object                                  
REFERENCED_TYPE      VARCHAR2(17)  Y                Type of referenced object                                  
REFERENCED_LINK_NAME VARCHAR2(128) Y                Name of dblink if this is a remote object                  
DEPENDENCY_TYPE      VARCHAR2(4)   Y                                                                            
To find all objects that reference the object MYOBJECT:
select * from all_dependenciens where referenced_name = 'MYOBJECT'
Back to top

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1