Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Any caveats about droping/recreating temp tablespce?
I've got a 7.3.4.5.0 instance on HP-UX 10.20 that's been workign great fro
years.
Now, some maintenance scripts are failing. Doing a little debuging reveals:
I shut down all of the applications accessing thsi dtabase, stoped it and restarted it. Then I did an "alter tablespace temp coalesce", but it's still pretty fragmented.
I'm considering droping and recreating the TEMP tablespace (it's just one 250M file).
I'm concerned about whether I will be able to do this though, since it seems liely that some system level functions may be using this tablespace.
Any caveats, or sugestions about my plan?
-- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." -- Benjamin FranklinReceived on Mon Jun 13 2005 - 09:14:32 CDT
![]() |
![]() |