Re: LOB Segments
From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 15 Oct 2008 21:51:12 -0700
Message-ID: <1224132667.795493@bubbleator.drizzle.com>
>
> 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.
Date: Wed, 15 Oct 2008 21:51:12 -0700
Message-ID: <1224132667.795493@bubbleator.drizzle.com>
joshua.olson_at_gmail.com 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 damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Wed Oct 15 2008 - 23:51:12 CDT