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!

Register Log in
  • 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!

Search results for query: *

  1. 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...

Part and Inventory Search

Back
Top