shrinking space
From: Eugene Pipko <eugene.pipko_at_unionbay.com>
Date: Tue, 31 May 2011 15:54:21 -0700
Message-ID: <34DB87F47199374280ADFD2968CDBCFA8888E92973_at_MAIL01KT.seattlepacificindustries.com>
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.
Date: Tue, 31 May 2011 15:54:21 -0700
Message-ID: <34DB87F47199374280ADFD2968CDBCFA8888E92973_at_MAIL01KT.seattlepacificindustries.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue May 31 2011 - 17:54:21 CDT