Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to resize temp tablespace
If your temp tablespace is made up of multiple tempfiles, you can...
-offline a tempfile
-drop the tempfile
-recreate the tempfile
Without the hassle of droping the tablespace
(almost worth the extra effort of creating a new datafile :)
HTH Received on Wed Nov 30 2005 - 10:44:14 CST
![]() |
![]() |