Take the tablespace offline first then you will be able to reduce the size.
Robert
"Huy Vu" <huyv_at_usa.net> wrote in message news:3bd76bdb_2_at_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 Thu Oct 25 2001 - 17:07:40 CDT
