LOB indexes and impdp

From: <Joel.Patterson_at_crowley.com>
Date: Fri, 11 Mar 2011 07:35:24 -0500
Message-ID: <C95D75DD2E01DD4D81124D104D317ACA16151D81ED_at_JAXMSG01.crowley.com>

I do a shema data pump export on 10.2.0.4 database on sparc 64. LOB indexes are named.

After import, Index names go away. Is this a known bug? Do I have to manually rename them? Did I do something wrong?

TABLE_NAME                     INDEX_NAME                     INDEX_TYPE


------------------------------ ------------------------------ ------------------------

BLEQUIPMENTINFO                BLEQUIP_DESCOFGOODSEN_LOG_IX   LOB
BLEQUIPMENTINFO                BLEQUIP_DESCOFGOODSES_LOG_IX   LOB

TABLE_NAME                     INDEX_NAME                     INDEX_TYPE


------------------------------ ------------------------------ ------------------------

BLEQUIPMENTINFO                SYS_IL0000179313C00048$$       LOB
BLEQUIPMENTINFO                SYS_IL0000179313C00049$$       LOB

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

Received on Fri Mar 11 2011 - 06:35:24 CST