1. 변경테이블에 대한 object 찾기
select *
from DBA_DEPENDENCIES
where owner = "INF"
--and referenced_type ="TABLE"
and referenced_name = "GC영업기회별수행결과"; -- 변경된 테이블

2. 소스라인 찾기
select *
from dba_source
where owner = "INF"
and TEXT like "%GC영업기회별수행결과%"; -- 해당 테이블이나 컬럼명



3. layout (참고사항임)
DBA_DEPENDENCIES----------------------------------------
Column Name ID Data Type Null?
OWNER 1 VARCHAR2 (30 Byte) N
NAME 2 VARCHAR2 (30 Byte) N
TYPE 3 VARCHAR2 (17 Byte) Y
REFERENCED_OWNER 4 VARCHAR2 (30 Byte) Y
REFERENCED_NAME 5 VARCHAR2 (64 Byte) Y
REFERENCED_TYPE 6 VARCHAR2 (17 Byte) Y
REFERENCED_LINK_NAME 7 VARCHAR2 (128 Byte) Y
DEPENDENCY_TYPE 8 VARCHAR2 (4 Byte) Y

dba_source----------------------------------
Column Name ID Data Type Null?
OWNER 1 VARCHAR2 (30 Byte) Y
NAME 2 VARCHAR2 (30 Byte) Y
TYPE 3 VARCHAR2 (12 Byte) Y
LINE 4 NUMBER Y
TEXT 5 VARCHAR2 (4000 Byte) Y

이 게시물을...