RE: Unix Command

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Thu, 20 Apr 2006 20:36:39 +0100
Message-ID: <D97D1FAE0521BD44820B920EDAB3BBAC0BF94071@ENYC11P32005.corpny.csfb.com>

Just yesterday I did a "drop tablespace ... including contents and datafiles" (9.2.0.6 on Solaris). The filesystem space freed up later, but not immediately after the drop.

Paul Baumgartel
paul.baumgartel_at_credit-suisse.com
212.538.1143

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mercadante, Thomas F (LABOR)
Sent: Thursday, April 20, 2006 2:43 PM
To: Oracle-L Freelists
Subject: Unix Command

All,

There is a unix command to show who has what files open on a mount point - anybody remember what it is?

We dropped a tablespace along with the data files, but the space was not released. I'm thinking that somehow Oracle did not release the space yet. Anybody remember something like this?

This is on Sun Solaris/9.2.0.5.

Thanks

Tom
--

http://www.freelists.org/webpage/oracle-l

Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html

--

http://www.freelists.org/webpage/oracle-l Received on Thu Apr 20 2006 - 14:36:39 CDT