When reverse-engineering the code for a table with a LOB segment (i.e. looking at the script tab for that table), the storage for the LOB index is
incorrect:
......
NOCACHE
INDEX (
TABLESPACE SWPLLOB128M01
STORAGE (
INITIAL 128M
NEXT 1 <-- SHOULD BE 128M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
))
STORAGE (
INITIAL 128M
.....
Here is what a query of dba_segments shows for the LOB segment and index:
SEGMENT_NAME SEGMENT_TYPE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE FREELISTS
------------------------------ ------------------ --------------- --------------- --------------- --------------- --------------- ---------------
SYS_IL0000486969C00004$$ LOBINDEX 134217728 134217728 1 2147483645 0 1
It shows that the NEXT_EXTENT should be 128MB and not 1, as stated in the table script.
WORKAROUND
Amend the script to reflect correct 'NEXT' extent size
STATUS:
Waiting for fix in a future release of Toad for Oracle
