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@xxxxxxxxxxxx Eugene Pipko wrote,on my timestamp of 1/06/2011 8:54 AM:
Hi all, Oracle 18.104.22.168 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