데이터베이스/오라클
오라클 DEPENDANCY CHECK SQL
쌀맛나는세상
2008. 1. 22. 14:28
select *
from SYS.DBA_dependencies
where referenced_type = 'TABLE'
and referenced_owner = '계정명'
and referenced_name in ('테이블명')
from SYS.DBA_dependencies
where referenced_type = 'TABLE'
and referenced_owner = '계정명'
and referenced_name in ('테이블명')