Re: shrinking space

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Tue, 31 May 2011 23:31:17 -0400
Message-ID: <5e6b2cf7-e79d-4cc8-8fa4-a3ac855c3852_at_blur>

Depending on if you can get maintenance window, I would CTAS new table with rows to keep, truncate original table, and then insert rows from temp table into empty table. Do as much as possible with nologging.

HTH,
-Mark

Sent from my Motorola ATRIX™ 4G on AT&T

-----Original message-----

From: Eugene Pipko <eugene.pipko_at_unionbay.com> To: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Wed, Jun 1, 2011 03:21:03 GMT+00:00 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-l Received on Tue May 31 2011 - 22:31:17 CDT

This message: [ Message body ]
Previous message: Matt McClernon: "Subquery (IN) is more efficient than JOIN"
Maybe in reply to: Eugene Pipko: "shrinking space"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message