Re: Help! Db table reorg problem...

From: John Kanagaraj <john.kanagaraj_at_gmail.com>
Date: Tue, 8 Jan 2008 16:31:20 -0800
Message-ID: <2ead3a60801081631h9bad46dn10368ea1a62941eb@mail.gmail.com>

Ben,

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
http://www.linkedin.com/in/johnkanagaraj http://jkanagaraj.wordpress.com (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 **
--

http://www.freelists.org/webpage/oracle-l Received on Tue Jan 08 2008 - 18:31:20 CST

This message: [ Message body ]
Next message: Orysia Husak: "Index clustering factor"
Previous message: Andrey Kriushin: "Re: Help w/ RMAN...."
In reply to: Ben Wittmeier: "RE: Help! Db table reorg problem..."
Next in thread: Ben Wittmeier: "RE: Help! Db table reorg problem..."
Reply: Ben Wittmeier: "RE: Help! Db table reorg problem..."

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

Original text of this message