반응형
데이터베이스 링크 없이 생성된 뷰에 대한 종속성을 포함하여 현재 사용자가 액세스할 수 있는 오브젝트(프로시저,패키지,함수,패키지 바디,트리거) 간의 종속성을 보여줍니다.
ColumnDatatypeNULLDescription
| Column | Datatype | NULL | Description |
| OWNER | VARCHAR2(128) | NOT NULL | Owner of the object |
| NAME | VARCHAR2(128) | NOT NULL | Name of the object |
| TYPE | VARCHAR2(18) | Type of the object | |
| REFERENCED_OWNER | VARCHAR2(128) | Owner of the referenced object (remote owner if remote object) 참조된 오브젝트의 오너 |
|
| REFERENCED_NAME | VARCHAR2(128) | Name of the referenced object 참조된 오브젝트의 이름 |
|
| REFERENCED_TYPE | VARCHAR2(18) | Type of the referenced object 참조된 오브젝트의 타입 |
|
| REFERENCED_LINK_NAME | VARCHAR2(128) | Name of the link to the parent object (if remote) 부모 오브젝트의 링크이름 |
|
| DEPENDENCY_TYPE | VARCHAR2(4) | Indicates whether the dependency is a REF dependency (REF) or not (HARD) 참조 디펜던시(REF) 나 그렇지 않으면 HARD로 표시 |
쿼리로 확인
SQL> select * from dba_dependencies
where owner='TEST';
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE REFERENCED_LINK_NAME DEPE
------------------------------ ------------------------------ ------------------ ------------------------------ ---------------------------------------------------------------- ------------------ -------------------------------------------------------------------------------------------------------------------------------- ----
TEST LINK_TEST PROCEDURE SYS STANDARD PACKAGE HARD
TEST CH10_EXCEPTION_PROC PROCEDURE SYS STANDARD PACKAGE HARD
TEST PL_DEL_DML_HIST_RESULT PROCEDURE SYS STANDARD PACKAGE HARD
TEST PL_INVALID_ALL_COMPILE PROCEDURE SYS STANDARD PACKAGE HARD
TEST TT PROCEDURE SYS STANDARD PACKAGE HARD
TEST PL_JOBTEST PROCEDURE SYS STANDARD PACKAGE HARD
TEST PL_USR_LOCK_CHK PROCEDURE SYS STANDARD PACKAGE HARD
TEST TEST_FCE01 TRIGGER SYS STANDARD PACKAGE HARD
TEST PL_DEL_DML_HIST_RESULT PROCEDURE PUBLIC ALL_DB_LINKS SYNONYM HARD
TEST PL_USR_LOCK_CHK PROCEDURE PUBLIC DBA_USERS SYNONYM HARD
TEST PL_INVALID_ALL_COMPILE PROCEDURE PUBLIC DBA_OBJECTS SYNONYM HARD
TEST PL_JOBTEST PROCEDURE PUBLIC DUAL SYNONYM HARD
TEST LINK_TEST PROCEDURE PUBLIC DBMS_OUTPUT SYNONYM HARD
TEST CH10_EXCEPTION_PROC PROCEDURE PUBLIC DBMS_OUTPUT SYNONYM HARD
TEST TT PROCEDURE PUBLIC DBMS_OUTPUT SYNONYM HARD
TEST PL_DEL_DML_HIST_RESULT PROCEDURE PUBLIC DBMS_OUTPUT SYNONYM HARD
TEST PL_INVALID_ALL_COMPILE PROCEDURE PUBLIC DBMS_OUTPUT SYNONYM HARD
TEST TEST_FCE01 TRIGGER PUBLIC DBMS_OUTPUT SYNONYM HARD
TEST PL_INVALID_ALL_COMPILE PROCEDURE PUBLIC DBA_SYNONYMS SYNONYM HARD
TEST CH10_EXCEPTION_PROC PROCEDURE SYS SYS_STUB_FOR_PURITY_ANALYSIS PACKAGE HARD
TEST TT PROCEDURE SYS SYS_STUB_FOR_PURITY_ANALYSIS PACKAGE HARD
TEST PL_USR_LOCK_CHK PROCEDURE SYS SYS_STUB_FOR_PURITY_ANALYSIS PACKAGE HARD
TEST EMP_SALESMAN VIEW TEST EMP TABLE HARD
TEST TT PROCEDURE TEST EMP TABLE HARD
TEST PL_USR_LOCK_CHK PROCEDURE TEST SQ_USER_STAT_HIST SEQUENCE HARD
TEST PL_DEL_DML_HIST_RESULT PROCEDURE TEST TB_DEL_DML_HIST_LOG TABLE HARD
TEST PL_USR_LOCK_CHK PROCEDURE TEST TB_USER_STAT_HIST TABLE HARD
TEST TEST_FCE01 TRIGGER TEST TESTLINK TABLE HARD
TEST TEST_FCE01 TRIGGER TEST TESTLINK2 TABLE HARD
TEST PL_DEL_DML_HIST_RESULT PROCEDURE TEST EMP TABLE XEE HARD
출처 : https://docs.oracle.com/database/121/REFRN/GUID-F9EA7DFB-5471-4B07-BDEF-FDE5DF57D1F4.htm#REFRN20053
ALL_DEPENDENCIES
ALL_DEPENDENCIES describes dependencies between procedures, packages, functions, package bodies, and triggers accessible to the current user, including dependencies on views created without any database links. This view does not display the SCHEMAID column
docs.oracle.com
반응형
'Oracle > 운영' 카테고리의 다른 글
| 다른 유저 테이블 Truncate 시키는 권한 (0) | 2021.10.25 |
|---|---|
| Locale의 LANG 과 Putty의 캐릭터셋 설정에 따른 한글 깨짐 현상 (0) | 2021.10.15 |
| [Oracle과 Tibero] DB link 에러 발생시 프로시저 에러발생여부 테스트 (0) | 2021.08.31 |
| 시퀀스(Sequence) Cache 옵션 유/무 , Order 옵션 유/무 테스트 (0) | 2021.08.05 |
| Sequence(시퀀스) (0) | 2021.08.02 |
댓글