RE: shrinking space
From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Wed, 1 Jun 2011 08:55:06 -0400
Message-ID: <SNT130-ds1107535A1562126D1E51AFA67D0_at_phx.gbl>
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?
Date: Wed, 1 Jun 2011 08:55:06 -0400
Message-ID: <SNT130-ds1107535A1562126D1E51AFA67D0_at_phx.gbl>
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Eugene Pipko
Sent: Tuesday, May 31, 2011 6:54 PM
To: oracle-l_at_freelists.org
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 01 2011 - 07:55:06 CDT