Re: LOB Segments

From: DA Morgan <>
Date: Wed, 15 Oct 2008 21:51:12 -0700
Message-ID: <> wrote:

>> Question: knowing a LOB segment contains just *column* data, why would
>> a LOB column be treated differently from an ordinary column?

> Umm, not quite what I meant... I don't know what's any particular LOB
> entry/segment.
> An entry in a LOB column is a link to a LOB segment if the LOB is
> larger than a certain size (4000 bytes I think), but if you archived/
> exported/deleted that table would it also archive/export/delete the
> LOB segments?
> My guess is that it would, but that's why I'm asking. I need to be
> certain.

For the purposes you are inquiring about the LOB segment may be thought of as part of the table just like the overflow of an IOT.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Wed Oct 15 2008 - 23:51:12 CDT

Original text of this message