Re: shrinking space

From: Hemant K Chitale <>
Date: Wed, 1 Jun 2011 15:22:13 +0800
Message-ID: <>

Get dowmtime and CTAS to a new table and then rename the tables.

Hemant K Chitale

sent from my smartphone
On 1 Jun 2011 07:32, "Eugene Pipko" <> wrote:
> Hi all,
> Oracle 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

Received on Wed Jun 01 2011 - 02:22:13 CDT

Original text of this message