OraFAQ Forum: Server Administration » How release Temporary Space???

Home » RDBMS Server » Server Administration » How release Temporary Space???

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How release Temporary Space??? [message #58614]

Mon, 22 September 2003 04:21

kothari Alpesh
Messages: 27
Registered: December 2001

Junior Member

I have production Database. In the Temporary Tablespace Its shows aprox. 58 MB space is used and approx 20 mb is free.

Total Free
Tablespace Space [[MB]] Space [[MB]] Free %
---------- ---------- --------- --------
TEMP 78.63 20.81 26.47

How can i release the used space.
There is no sorting operation is going on the Database.This is the listing from DBA_EXTENTS

Name ID Segment Segment ID Blocks
Name Type
----- -- -------- --------- --- ------
TEMP 4 4.16578 TEMPORARY 82 80
4.16578 TEMPORARY 274 80
4.16578 TEMPORARY 434 80
4.16578 TEMPORARY 514 80
4.16578 TEMPORARY 642 80
4.16578 TEMPORARY 770 80
Can anybody explain/help to me...

Thanking You

Report message to a moderator

Re: How release Temporary Space??? [message #58615 is a reply to message #58614]

Mon, 22 September 2003 05:48

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

The sort extents are not de-allocated while the instance is running, but are marked as free and can be re-used as required.
so there is NO need to free the space ( as long as the tablespace is defined as temp temporary tablespace).
if you insist, toggle the database.

Report message to a moderator

Re: How release Temporary Space??? [message #58617 is a reply to message #58615]

Mon, 22 September 2003 06:27

Thiru
Messages: 1089
Registered: May 2002

Senior Member

Mahesh,I am sure you meant 'toggle the tablespace' and not 'toggle the database' ie make the TEMP tablespace PERMANENT and back again to 'TEMPORARY'.

Thiru

Report message to a moderator

Re: How release Temporary Space??? [message #58622 is a reply to message #58617]

Mon, 22 September 2003 10:20

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

yup...a typo~!

Report message to a moderator

Previous Topic:	Schedule Tasks commands in Oracle
Next Topic:	help me

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:30:00 CDT 2024