Re: LOB indexes and impdp
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 11 Mar 2011 13:20:53 -0000
Message-ID: <4A8E1BB8CFD54572AA8E5CC828AC0BB9_at_Primary>
>From: <Joel.Patterson_at_crowley.com>
>To: <oracle-l_at_freelists.org>
>Sent: Friday, March 11, 2011 12:35 PM
>Subject: LOB indexes and impdp
>
Date: Fri, 11 Mar 2011 13:20:53 -0000
Message-ID: <4A8E1BB8CFD54572AA8E5CC828AC0BB9_at_Primary>
>From: <Joel.Patterson_at_crowley.com>
>To: <oracle-l_at_freelists.org>
>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-lReceived on Fri Mar 11 2011 - 07:20:53 CST