Re: 'drop tablespace' produces a file/table lock??

From: Tanel Poder <tanel_at_@peldik.com>
Date: Fri, 25 Jul 2003 20:30:07 +0300
Message-ID: <3f21691e_1@news.estpak.ee>

> What Unix does allow to do is for you to delete a "locked" file. Or
> use to in the old days when we still had 2GB max file systems.
>
> What you deleted were the file name entry.. the i/o nodes allocated to
> that file was not released until after the lock has been released.
> Thus you could "delete" a massive file and do a df/bdf and still see
> no free space as a result.

Hi!

At least using 8.1.7.1 on Solaris 8, Oracle actually closes the file when taken offline or dropped. You can verify it with "fuser" command for example.

Tanel. Received on Fri Jul 25 2003 - 12:30:07 CDT