Re: LOB Segments

From: <sybrandb_at_hccnet.nl>
Date: Wed, 15 Oct 2008 21:42:57 +0200
Message-ID: <6shcf4dassbu7khh4fjj3dua5lg3h92lmu@4ax.com>


On Wed, 15 Oct 2008 11:55:49 -0700 (PDT), joshua.olson_at_gmail.com wrote:

>As I understand it oracle tables link the LOB column to a a LOB
>segment that actually stores the LOB.
>
>My question is when you archive/export/delete/etc. that table does
>that also affect the LOB segment? So, in other words if you archived
>it would that also archive the LOB segments? My guess is that it
>does, but I just want to be sure.

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

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Wed Oct 15 2008 - 14:42:57 CDT

Original text of this message