RE: shrinking space

  • From: Michael McMullen <ganstadba@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 1 Jun 2011 08:55:06 -0400

Do you need to reclaim the space at all? How much space is wasted?
Hopefully, the blob/clob columns weren't populated and so the space wastage
isn't that much. What do the segment size show in dba_segments?

 

Maybe metalink note 386341.1 will help.

 

  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Eugene Pipko
Sent: Tuesday, May 31, 2011 6:54 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: shrinking space

 

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: