Re: How to migrate/recreate LOB indexes to/on another database

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_at_gmail.com 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.
>

--
http://www.freelists.org/webpage/oracle-l