http://www.dba.5341.com/
http://www.dba.5341.com/
You might have to do it, prior to removing
the file.
From: Alfonso León
[mailto:aleon68@gmail.com]
Sent: Friday, July 07, 2006 6:58
PM
To: Allen, Brandon
Cc: kennaim@gmail.com; oracle-l
Subject: Re: Linux does not show
the freed space by a drop tablespace
yep, I used lsof, but it doesn't show a process using the filesystem
where it was the datafile.
On 7/7/06, Allen,
Maybe fuser or lsof?
From: oracle-l-bounce@freelists.org
[mailto:
oracle-l-bounce@freelists.org] On Behalf
Of Ken Naim
Sent: Friday, July 07, 2006 4:37
PM
To: aleon68@gmail.com;
'oracle-l'
Subject: RE: Linux does not show
the freed space by a drop tablespace
. . . When I used to
work on solaris 9 we used a command (which currently escapes me) that listed
all the process id's that had handles on each datafile . . .
Privileged/Confidential Information may be
contained in this message or attachments hereto. Please advise immediately if
you or your employer do not consent to Internet email for messages of this
kind. Opinions, conclusions and other information in this message that do not
relate to the official business of this company shall be understood as neither
given nor endorsed by it.
--
Alfonso Leon