You might check out Red Gate. Their Schema Compare product can produce a
script to generate objects similar to a Data Pump metadata only, but you can
review & edit the script. I’m honestly not sure about case sensitivity, as I
haven’t had to deal with it, but there are plenty of parameters that can be set
when comparing schemas.
There’s a 30 day trial (IIRC), so aside from a sales call or 2, it might even
be free.
Thanks,
T. J.
The information contained in this message is privileged and confidential
information intended only for the use of the individual or entity identified
above. If the receiver of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution, use or copying of this
message is strictly prohibited. If you have received this message in error,
please immediately notify the sender by replying to his/her e-mail address
noted above and delete the original message, including any attachments. Thank
you.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Norman Dunbar
Sent: Wednesday, April 27, 2016 5:57 AM
To: howard.latham@xxxxxxxxx
Cc: ORACLE-L
Subject: Re: Case sensitive user defined types, 11g imp and my current
nightmare!
Morning Howard,
yes, datapump would be better, but sadly the source database is 9i. :-(
And restricted access. (Sensitve personal data.)
And air-gapped.
Basically, I'm stuffed. Destined to spend my life waiting 23 hours for a task
to work or fail! Still, I have other work to get on with...
Cheers,
Norm.
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
