RE: Help! Db table reorg problem...

From: Ben Wittmeier <>
Date: Wed, 9 Jan 2008 16:02:30 -0700
Message-ID: <>

Sorry for taking so long to get back to this - been too busy. No - there are no LOBs, CLOBs or similar in the table - just varchar2, date, number.

-----Original Message-----

From: John Kanagaraj [] Sent: Tuesday, January 08, 2008 5:31 PM
To: Ben Wittmeier
Cc:; Subject: Re: Help! Db table reorg problem...


Do you have LOBs in this table? Be aware that LOBs don't use the traditional Rollback/Undo segments, but use DB Blocks within the table to store the entire LOB in case of DML: This little "feature" has caught many of us...


John Kanagaraj <><
DB Soft Inc (Sorry - not an Oracle blog!) ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.

-- Received on Wed Jan 09 2008 - 17:02:30 CST

Original text of this message