alter index 인덱스이름 rebuild tablespace 새로운테이블스페이스; 예제 1 select TABLE_NAME, INDEX_NAME, INDEX_TYPE, TABLESPACE_NAME from user_indexes 2* where TABLE_NAME='STUDENT' SQL> / TABLE_NAME INDEX_NAME INDEX_TYPE TABLESPACE ------------------------------ ------------------------------ --------------------------- ---------- STUDENT IDX_STUD_DEPTNO NORMAL USERS STUDENT IDX_STUD_PROFNO NORMAL USERS STUDENT IDX..