RE: shrinking space

From: Joel Slowik <jslowik_at_cps92.com>
Date: Wed, 1 Jun 2011 07:45:51 -0400
Message-ID: <7FCAE6F848605649B090362F7C518C4803F6B8CC_at_cpsexchange.cps92.com>



You may also try using the shrink space clause of alter table.  

http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/statement s_3001.htm#i2192484

That's half way though, if you are pressed for physical disk space then the shrink space command or an export/import of a specific table may not help that much since the datfiles will still have the space allocated; even if the table frees the space.  

For that, I'll direct you to asktom:
http://asktom.oracle.com/pls/asktom/f?p=100:11:4000442744825987::::P11_Q UESTION_ID:153612348067    
-joel slowik
 

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Eugene Pipko Sent: Tuesday, May 31, 2011 6:54 PM
To: oracle-l_at_freelists.org
Subject: shrinking space  

Hi all,

Oracle 9.2.0.8 on Win 2003.

SAP admitted a bug in their app, which resulted in millions of rows inserted in a couple of tables.

They came up with a script to delete them, but failing to provide any solutions on how to reclaim unused space.

One of the tables has CLOB column and another has BLOB column in them.  

Question: how do I shrink tables with CLOB and BLOB columns?  

Thanks,

Eugene  

Confidentiality Note: This electronic message transmission is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. If you have received this transmission, but are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this information is strictly prohibited. If you have received this e-mail in error, please contact Continuum Performance Systems at {203.245.5000} and delete and destroy the original message and all copies.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jun 01 2011 - 06:45:51 CDT

Original text of this message