Re: shrinking space
From: Nuno Souto <dbvision_at_iinet.net.au>
Date: Wed, 01 Jun 2011 20:12:26 +1000
Message-ID: <4DE6108A.1080502_at_iinet.net.au>
If you are really pressed for disk space, I'd suggest: delete offending rows,
export the table,
truncate it,
then import with ignore=y and destroy=n so that it doesn't change anything in the current allocation or grants, just loads rows. HTH
Date: Wed, 01 Jun 2011 20:12:26 +1000
Message-ID: <4DE6108A.1080502_at_iinet.net.au>
If you are really pressed for disk space, I'd suggest: delete offending rows,
export the table,
truncate it,
then import with ignore=y and destroy=n so that it doesn't change anything in the current allocation or grants, just loads rows. HTH
-- Cheers Nuno Souto dbvision_at_iinet.net.au Eugene Pipko wrote,on my timestamp of 1/06/2011 8:54 AM:Received on Wed Jun 01 2011 - 05:12:26 CDT
> 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