Okay... I want to improve some disk space by moving temporary tablespaces to another physical disk, however, im thinking I cant do this w/o dropping and recreating since i cant take a temporary tablespace offline to move it. ora can I? -- Bryan S Wells - DBA Newbie bunjibry@xxxxxxxxx -- //www.freelists.org/webpage/oracle-l