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

From: Tanel Poder <tanel_at_@peldik.com>
Date: Mon, 28 Jul 2003 10:53:37 +0300
Message-ID: <3f24d681$1_1@news.estpak.ee>

Ok, silly me ;)

Tanel.

"Quarkman" <quarkman_at_myrealbox.com> wrote in message news:6f2ab2f8.0307272210.652bde72_at_posting.google.com... > "Tanel Poder" <tanel@@peldik.com> wrote in message news:<3f21b1c6$1_1_at_news.estpak.ee>...
> > > > 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!

> >
> > Fuser is a quite standard unix command to check which processes have a file

> > open.
> > Quote from Solaris man page:
> >
> >
> > NAME
> >      fuser - identify processes using a file or file structure
> >
> > SYNOPSIS
> >      /usr/sbin/fuser [  -
> >       [ c | f ]  ku  ]  files  [  [  -
> >       [ c | f ]  ku  ]  files  ]   ...
> >
> > DESCRIPTION
> >      fuser displays the process IDs of  the  processes  that  are
> >      using the files specified as arguments.
> >
> > Cheers,
> > Tanel.
>
>
> (It was a joke!!).
> ~QM

Received on Mon Jul 28 2003 - 02:53:37 CDT