▣ 다른 테이블 스페이스와 독립적이어야 함
▶ index가 다른 t/s에 있는 경우
▶ Partitioned table이나 index
▶ 다른 테이블 객체 references 하는 경우
select distinct tablespace_name from dba_tables
where (owner,table_name) in (
select OWNER,TABLE_NAME from dba_constraints
where (R_OWNER,R_CONSTRAINT_NAME) in (
select OWNER,SEGMENT_NAME from dba_segments
where segment_type='INDEX' and tablespace_name='EXAMPLE')
)
/
TABLESPACE_NAME
------------------------------
USERS => users가 문제
EXAMPLE
select owner,table_name from dba_tables
where (owner,table_name) in (
select OWNER,TABLE_NAME from dba_constraints
where (R_OWNER,R_CONSTRAINT_NAME) in (
select OWNER,SEGMENT_NAME from dba_segments
where segment_type='INDEX' and tablespace_name='EXAMPLE')
)
and tablespace_name='USERS'
OWNER TABLE_NAME
------------------------------ ------------------------------
SH CUSTOMERS
댓글 없음:
댓글 쓰기