Re: Disk space did not release

you should run "DROP TABLESPACE TEMP2 INCLUDING CONTENTS AND DATAFILES;" to drop file and release space on disk.

Now you have to delete file manually to release space on disk.

Regards,
Marko

On Sun, May 18, 2014 at 12:18 PM, Eriovaldo Andrietta <ecandrietta_at_gmail.com
> wrote:

> Hi friends,
>
> I had a temporary tablespace TEMP02 in the instance.
>
> I ran:
> $ df -h .
> Filesystem Size Used Avail Use% Mounted on
> /dev/f1/fold1 493G 154G 339G 32% /l/disk67
>
> After it I ran :
> select * from dba_temp_files;
> I got the file : /l/disk67/app/oracle/oradata/instance_name/temp02.dbf
>
> I ran:
> drop tablespace TEMP2;
>
> So I immediately ran
> $ df -h .
> Filesystem Size Used Avail Use% Mounted on
> /dev/f1/fold1 493G 154G 339G 32% /l/disk67
>
> and the spaces was not released. It keeps with 339G Avail
>
> The SO is Linux
> The database is 11g
>
> What is wrong ?
> Disk space should be released immediately?
>
> Regards
> Eriovaldo
>
>
>

--
http://www.freelists.org/webpage/oracle-l