Re: shrinking space
- From: Hemant K Chitale <hemantkchitale@xxxxxxxxx>
- To: eugene.pipko@xxxxxxxxxxxx
- Date: Wed, 1 Jun 2011 15:22:13 +0800
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@xxxxxxxxxxxx> 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
>
Other related posts:
