Re: Disk space did not release
- From: Marko Sutic <marko.sutic@xxxxxxxxx>
- To: ecandrietta@xxxxxxxxx, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 18 May 2014 12:34:08 +0200
Hello Eriovaldo,
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@xxxxxxxxx
> 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
>
>
>
Other related posts:
