how to resize temp tablespace

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

T - 30 Nov 2005 11:44 GMT

I need to resize temporary tablespace from 1,5 GB to 200 MB on Oracle
9.2.0.1

Please advice!!
Tnx!

Reply to this Message

Frank van Bortel - 30 Nov 2005 11:56 GMT

> I need to resize temporary tablespace from 1,5 GB to 200 MB on Oracle
> 9.2.0.1
>
> Please advice!!
> Tnx!

drop & recreate

Signature

Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Reply to this Message

G Quesnel - 30 Nov 2005 16:44 GMT

If your temp tablespace is made up of multiple tempfiles, you can...
-offline a tempfile
-drop the tempfile
-recreate the tempfile
Without the hassle of droping the tablespace
(almost worth the extra effort of creating a new datafile :)

HTH

Reply to this Message