Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by petemahaf
-
how can i empty the temp tablespace
you could try just resetting the storage parameters for the TEMP tablespace. This can be done at any time. ALTER TABLESPACE temp DEFAULT STORAGE (pctincrease 0); This will re-allocate the extents not in use and so clear the tablespace. It will not last as Oracle allocates and does not...- petemahaf
- Post #8
- Forum: Oracle: All versions
