A LOBINDEX is automatically created for each LOBSEGMENT (in the same
Tablespace).
Do you have LOB Segments -- in the source database ?
How are the LOB columns defined -- storage to be Inline pr OutOfLine (i.e.
in a separate LOB Segment) ?
On Tue, 13 Nov 2018, 07:30 Sundar Mahadevan <sundarmahadevan82@xxxxxxxxx
wrote:
Hi All,
Greetings. I recently performed a TTS migration and I notice that LOB
indexes on a particular table are missing. How do i recreate them or
migrate them from source? The sqlfile generated from full metadata from
source does not have these indexes. Neither does Toad generate the sql for
the lob indexes. Appreciate your assistance. Thanks.
