OraFAQ Forum: Server Administration » 'clean' temporary tablespace in 9i

Home » RDBMS Server » Server Administration » 'clean' temporary tablespace in 9i

Mon, 29 April 2002 13:17

JZ
Messages: 8
Registered: March 2002

Junior Member

Since TEMP tablespace is full, how to 'clean' the temporary tablespace without bounce the database?

Oracle 9i

Thanks a lot!

Mon, 06 May 2002 12:26

Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida

Senior Member

alter tablespace temp default storage (pctincrease 0);

Good luck.

Mon, 15 December 2003 02:52

patrick
Messages: 83
Registered: December 2000

Member

But if we have a locally managed tablespace, it's impossible to alter the storage settings??

Is there any alternative?

Many thanks!

Patrick.

Previous Topic:	Default temporary tablespace
Next Topic:	Regarding order by

Goto Forum:

]

Current Time: Fri Sep 20 13:36:07 CDT 2024