RE: LOB indexes and impdp
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <jonathan@xxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 11 Mar 2011 15:17:05 -0500
Thanks,
I love it. I've come to the point where if you ask someone to look over you
shoulder and it just starts working, then great, I'm done... even if I had to
change a character.
My index name disappearing on the LOB is just a claring example of something
standing out in my output where nothing should be listed. My script covers
all kinds of objects and in this case covers many dictionary views. The index
name was but one.
I figure if you can name it, then oracle should keep it. If not, why not? Is
it 'fixed' in 11g, 12g?
I can 'duplicate' the database which I normally do, and everything is correct,
Datapump should not be taking upon itself to ignore names one was able to
create, and painstakingly took the time to name. It's like painting an
object, and your apprentice who duplicates it, has decided that flat white is
easier and goes with it. It still functions, but is not as professional.
Joel Patterson
Database Administrator
904 727-2546
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Jonathan Lewis
Sent: Friday, March 11, 2011 10:53 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: LOB indexes and impdp
Not quite the same issue - but there's an entertaining example of that at:
http://mwidlake.wordpress.com/2011/03/11/if-you-really-cant-solve-a-simple-problem/
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
----- Original Message -----
From: "Mark W. Farnham" <mwf@xxxxxxxx>
To: <Joel.Patterson@xxxxxxxxxxx>; <jonathan@xxxxxxxxxxxxxxxxxx>;
<oracle-l@xxxxxxxxxxxxx>
Sent: Friday, March 11, 2011 3:40 PM
Subject: RE: LOB indexes and impdp
> Relying on index names as a sign of the indexes matching is a leap of faith
> that can blindside you to a difference.
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
