Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Any caveats about droping/recreating temp tablespce?
Assign the SYSTEM tablespace as TEMP tablespace to all users, before
you recreate the tablespace.
Recreate the tablespace.
Make sure PCT_INCREASE is 0, and all extents are equally sized!!!!
Assign the new tablespace as TEMP tablespace to all users.
-- Sybrand Bakker Senior Oracle DBAReceived on Mon Jun 13 2005 - 09:31:28 CDT