Re: LOB indexes and impdp

From: <Joel.Patterson@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, March 11, 2011 12:35 PM
Subject: LOB indexes and impdp
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?
You're not supposed to know anything about the LOB indexes - and although the syntax exists to name them you're not supposed to use it. Presumably, therefore, the code that extracts the LOB DDL on export doesn't bother to query for the lobindex name. 

Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com


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

Other related posts: