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

From: Quarkman <quarkman_at_myrealbox.com>
Date: Sat, 26 Jul 2003 06:51:59 +1000
Message-ID: <oprsvv8xaur9lm4d@haydn>

On Fri, 25 Jul 2003 20:30:07 +0300, Tanel Poder <tanel@@peldik.com> wrote:

>> 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.

"Fuser command"?? Is that the one that short-circuits your server room??

A novel approach to getting the file system to remove files, but I imagine it would be quite effective!

;-)
QM Received on Fri Jul 25 2003 - 15:51:59 CDT