Skip to the content.

ORA-60100: dropping temporary tablespace with tablespace ID number (tsn) %s is blocked due to sort segments

Temporary 테이블스페이스 삭제에 실패함 (sort segments)

  1. 필요하다면 강제삭제
     DROP TABLESPACE temp_tablespace_name INCLUDING CONTENTS AND DATAFILES;