RE: LOB indexes and impdp

Interesting.

Of course, if one wishes to compare schemas between production, acceptance, etc. etc. and have a log of LOB columns, then as a 'difference' they will always stand out because all the names start with SYS%.

I can move the LOB column this way, and then if I select from user_indexes minus select from user_indexes_at_otherdb zero rows will be returned. It is after all an index_name.

alter table BLEQUIPMENTINFO add (DESCOFGOODSES_TMP CLOB)   LOB (DESCOFGOODSES_TMP) STORE AS BLEQUIP_DESCOFGOODSES_SEG       (TABLESPACE INDEX1 INDEX BLEQUIP_DESCOFGOODSES_LOG_IX (TABLESPACE INDEX1)); update BLEQUIPMENTINFO set DESCOFGOODSES_TMP=DESCOFGOODSES;

alter table BLEQUIPMENTINFO drop column DESCOFGOODSES;

alter table BLEQUIPMENTINFO rename column DESCOFGOODSES_TMP to DESCOFGOODSES;

Joel Patterson
Database Administrator
904 727-2546

Joel Patterson
Database Administrator
904 727-2546

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jonathan Lewis Sent: Friday, March 11, 2011 8:21 AM
To: oracle-l_at_freelists.org
Subject: Re: LOB indexes and impdp

>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-l


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