RE: Case sensitive user defined types, 11g imp and my current nightmare!

Other than giving it the fastest underlying storage possible and priority on cpus for the interpretive part I’m not sure there is an easy way. (I’m presuming the source of the export is unavailable, of course then you’d just do a fresh export of just that table.)  

If you import *no rows* it may be possible to get the table metadata, manipulate the definition to accept data and be as forgiving as possible, import ignoring that the table already exists, and then see what you can do with the data once you get it in.  

Good luck.  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Norman Dunbar Sent: Wednesday, April 27, 2016 11:03 AM To: TJ Kiernan
Cc: ORACLE-L
Subject: RE: Case sensitive user defined types, 11g imp and my current nightmare!  

Thanks.

I'm not 100%certain how a schema compare script would help me here, but I'm not familiar with the Red Gate application, I use Toad.

My problem is that I'm trying to import one table, with dependent user defined types, from a 160ish Gb exp file. It takes 23 hours approximately to get to where the table starts in the file. My workaround testing is pretty abysmal I'm afraid as each test run takes forever to get to the data, and then minutes to fail. :-(

I havent fed my exp file into Toad's export file explorer as I suspect it will blow out my desktop PC's RAM, swap space, etc. Maybe I will, soon though, just for fun!

Cheers,
Norm.
--

Sent from my Android device with K-9 Mail. Please excuse my brevity.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 27 2016 - 18:06:42 CEST