Oracle only keeps the pointer to a lob in the table, not the actual data,
unles is less than 2K.
When you creat your table you can specify in which taable space store the
lob objects.
Check the default table space of the user, and the table DDL.
Tom
donovans <donovans_at_my-deja.com> wrote in message
news:8cmub2$v2a$1_at_nnrp1.deja.com...
> I have a table containing a clob column. The storage for the lob is
> defined as being 'in row' yet I am getting lob extents appearing in the
> system tablespace segment. Its of particular concern to me as it
> prevents my planned use of transportable tablespaces, as by definition
> the tablespace content must be isolated ie no dependants on other
> tablespaces.
>
> Any clues are more than welcome.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Apr 10 2000 - 00:00:00 CDT
