just doing drop and recreate, temporary datafile didnot support move. On Sun, 9 Jan 2005 10:55:13 -0700 Bryan Wells <bunjibry@xxxxxxxxx> wrote: > 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 -- Kamus <kamusis@xxxxxxxxx> 那么多1G的邮箱,我能用来干什么:-) A Oracle8i & 9i Certified DBA from China -- //www.freelists.org/webpage/oracle-l