Re: LOB Table space
From: Zot <wiz_au_at_yahoo.com.au>
Date: Sat, 19 Apr 2008 20:42:05 +1000
Message-ID: <fuci9e$gl6$1@registered.motzarella.org>
Date: Sat, 19 Apr 2008 20:42:05 +1000
Message-ID: <fuci9e$gl6$1@registered.motzarella.org>
OD wrote,on my timestamp of 18/04/2008 11:46 PM:
> Hello,
>
> I made a table with 1 blob field, and a specific lob tablespace to store
> the lob column.
>
> If i insert a row with nothing in the blob field, 1 MB is reserved for it in
> the lob tablespace.
> The blob field is NULL.
>
> Do someone have any idea ?
>
> Olivier.
>
>
Run this:
SQL> select dbms_metadata.get_ddl('TABLE','<table_name') from dual;
substituting the table_name for what it is, then post here the results.
Also, read this:
http://dbasrus.blogspot.com/2007_02_01_archive.html
for info on some LOB gotchas.
Received on Sat Apr 19 2008 - 05:42:05 CDT