RE: Help! Db table reorg problem...
- From: "Ben Wittmeier" <Ben.Wittmeier@xxxxxxxxx>
- To: "John Kanagaraj" <john.kanagaraj@xxxxxxxxx>
- Date: Wed, 9 Jan 2008 16:02:30 -0700
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 [mailto:john.kanagaraj@xxxxxxxxx]
Sent: Tuesday, January 08, 2008 5:31 PM
To: Ben Wittmeier
Cc: mark.powell@xxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Help! Db table reorg problem...
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 **
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
