Temporary Tablespace
(1) The DEFAULT TEMPORARY TABLESPACE must be of TEMPORARY type.
(2) The DEFAULT TEMPORARY TABLESPACE cannot be converted to PERMANENT once it has been defined as the DEFAULT TEMPORARY TABLESPACE.
(3) Before dropping the DEFAULT TEMPORARY TABLESPACE, create another one.
(4) The DEFAULT TEMPORARY TABLESPACE cannot be taken OFFLINE:
(5) The temporary tablespace for users must be of TEMPORARY type in Oracle9i.(Please note, this is not a restriction in Oracle8 and Oracle8i.)
(6) If you drop the temporary tablespace of a user, and this temporary tablespace is not the DEFAULT TEMPORARY TABLESPACE for the database, the user’s temporary tablespace is not automatically switched to the DEFAULT TEMPORARY TABLESPACE.