Re: shrinking space

  • From: Nuno Souto <dbvision@xxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 01 Jun 2011 20:12:26 +1000

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.

Nuno Souto

Eugene Pipko wrote,on my timestamp of 1/06/2011 8:54 AM:
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?




Other related posts: