ORA-60102
creating a new sort segment for temporary tablespace (tsn):string (con_id):string is blocked due to inactive sort segments for the tablespace not being dropped
Cause
The temporary tablespace has inactive sort segments which have not been dropped. This could be caused due to long running sessions that are still consuming temporary space.
Action
Execute the following query to check if there are any sessions still consuming temporary space from the inactive sort segments: select USERNAME, SESSION_ADDR, SESSION_NUM, SQLADDR, SQL_ID, BLOCKS from v$sort_usage where ts#=(&tsn); If there are any active sessions, wait for them to complete or terminate the session.
If there are no active sessions consuming temporary space from the inactive sort segments, restart the instance to drop the inactive sort segments. The process trace file contains additional diagnostics to investigate the issue.