Sort segments are used when a segment is shared by multiple sort operations. One sort segment exists for every instance that performs a sort operation in a given tablespace.
这个主意不是很好，但却能满足楼主的意思。1：创建一个TEMPORARY TABLESPACE TEMP2 CREATE TEMPORARY TABLESPACE "TEMP2" TEMPFILE '/oracle/oradata/test/ TEMP2.dbf' SIZE 5M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;2：把当前TEMPORARY TABLESPACE切换到TEMP2上 ALTER DATABASE DEFAULT TEMPORARY TABLESPACE "TEMP2";3：删除以前的TEMPORARY TABLESPACE4：重建以前的TEMPORARY TABLESPACE5：把当前TEMPORARY TABLESPACE切换到原来的TEMP上这就可以用上了，没有shutdown----下面是介绍TEMPORARY TABLESPACE的一段内容---- Within a temporary tablespace, all sort operations for a given instance and tablespace share a single sort segment. Sort segments exist for every instance that performs sort operations within a given tablespace. The sort segment is created by the first statement that uses a temporary tablespace for sorting, 【after startup, and is released only at shutdown.】 An extent cannot be shared by multiple transactions.
CREATE
TEMPORARY TABLESPACE "TEMP2" TEMPFILE '/oracle/oradata/test/
TEMP2.dbf' SIZE 5M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;2：把当前TEMPORARY TABLESPACE切换到TEMP2上
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE "TEMP2";3：删除以前的TEMPORARY TABLESPACE4：重建以前的TEMPORARY TABLESPACE5：把当前TEMPORARY TABLESPACE切换到原来的TEMP上这就可以用上了，没有shutdown----下面是介绍TEMPORARY TABLESPACE的一段内容----
Within a temporary tablespace, all sort operations for a given instance and tablespace share a single sort segment. Sort segments exist for every instance that performs sort operations within a given tablespace. The sort segment is created by the first statement that uses a temporary tablespace for sorting, 【after startup, and is released only at shutdown.】 An extent cannot be shared by multiple transactions.