Cannot resize TEMP tablespace from OEM

From: Huy Vu <huyv_at_usa.net>
Date: Wed, 24 Oct 2001 21:38:49 -0400
Message-ID: <3bd76bdb_2@aeinews.>

Hi all,

The temp01.dbf of TEMP tablespace of Oracle 8.1.7 64bits on HP-UX 11 were created with 200MB with autoextend on /ora05 FS of 1GB.

Suddenly, the TEMP extend the size and make full the /ora05 FS.

There is only 2MB space used in TEMP tablespace so I want to reduce the size of temp01.dbf to free up the space of /ora05 FS with OEM 8.1.6 for Win2000 but it failed.

Why OEM report only 2MB space used on 950MB space but cannot reduce the size of the datafile temp01.dbf?

Thanks in advance for any advise

DH Received on Wed Oct 24 2001 - 20:38:49 CDT