-- 1. sample syntax
create temporary tablespace temp2  tempfile  '/dev/vx/rdsk/dev/temp2'
        size 2048 M reuse
        extent management local
        uniform size 1m ;
-- 2.
-- first create the temp tablespace
-- make it defualt.. all databaase users are automatically assigned with new temp tablespace
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP2;
-- drop the old one
drop tablespace temp including contents;