Hello guys,
a little question about the LOB segments and inline or outline storage.
The following example table:
SQL> select * from all_lobs where table_name = 'TEST';
OWNER TABLE_NAME COLUMN_NAME SEGMENT_NAME TABLESPACE_NAME INDEX_NAME CHUNK PCTVERSION RETENTION FREEPOOLS CACHE LOGGING IN_ROW FORMAT PARTITIONED
------------------------------ ------------------------------ ----------------------- ------------------------------ ------------------------------ ------------------------------ ---------------------- ---------------------- ---------------------- ---------------------- ---------- ------- ------ --------------- -----------
MYUSER TEST BLOCK SYS_LOB0000021682C00009$$ MYTABSPACE SYS_IL0000021682C00009$$ 8192 43200 YES YES YES ENDIAN NEUTRAL NO
As you can see the column BLOCK of the table TEST is stored as inline.
I have found the following LOB Internals Paper:
http://integrid.info/Poder_LOB_Internals.pdf
As described on page 12:
-> enable storage in row inline LOB
--> Max. total column size 4000 bytes
--> No LOB index entries
--> No LOB segment entries
But in my case i can see an LOB Index called SYS_IL0000021682C00009$$. Why is there one when it is never used for INLINE LOBs?
The background of my question is the DBMS_REPAIR Package limitation:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/repair002.htm
-> Tables with LOB datatypes, nested tables, and varrays are supported, but the out of line columns are ignored.
Regards
Stefan