Re: shrinking space

From: Hemant K Chitale <hemantkchitale_at_gmail.com>
Date: Wed, 1 Jun 2011 15:22:13 +0800
Message-ID: <BANLkTi=+itSGG3YSwM8in6OF=q63PVOCKg_at_mail.gmail.com>

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

Hemant K Chitale
http://hemantoracledba.blogspot.com
http://hemantscribbles.blogspot.com

sent from my smartphone
On 1 Jun 2011 07:32, "Eugene Pipko" <eugene.pipko_at_unionbay.com> wrote:
> 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-l

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