Somebody else mentioned the same thing with 9i, AIX on EMC Symmetrix.
She dropped a tablespace and datafiles. It took 12 hours or more
before they could reuse it.
i'd love to know if this is an oracle issue or OS. Right now it's just finger pointing.
Steve
On Apr 20, 2006, at 02:36 PM, Baumgartel, Paul wrote:
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@xxxxxxxxxxxxxxxxx 212.538.1143
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]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 -- //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
====================================================================== ========
-- //www.freelists.org/webpage/oracle-l
-- //www.freelists.org/webpage/oracle-l
