Cc to list. I forgot to reply all. Sigh.
-------- Original Message --------
From: Norman Dunbar <oracle@xxxxxxxxxxxxxxx>
Sent: 28 April 2016 15:58:07 BST
To: "Mark W. Farnham" <mwf@xxxxxxxx>
Subject: RE: Case sensitive user defined types, 11g imp and my current
nightmare!
Hi Mark,
at the moment, yes. The source database has moved on by over a week. So at the
moment I'm stuck with this 160Gb export file. The next refresh has been
requested differently after a bit of analysis, I've (hopefully) worked out the
optimum set of tables and schemas to export in separate sessions to give me 4
dump files that I can then use to improve performance.
Time will tell, but one single table holds around 45% of the total number of
rows which is about 1.5 billion. Lots of CLOBs, XMLTYPES and other nasties
involved. That one is the cause of all the delays as it is closer to the 'A'
end of the alphabet than the table Ineed, which is in amongst the 'X' end.
It takes about 4 to 5 days to get the production DBAs to supply an export as it
has to be consitent, and the personal data obfuscated. It all adds to the
delays.
I've even tried to find out, with zero success, the internal structure of a exp
dump file to see if there was some way of perhaps slicing the file into just
the sections I need. No joy. I've done this before with tar files, but thay are
documented. These exp files don't appear to be, at least not publically. I've
worked a few details out myself (direct or not, user exporting, original file
name, date etc - the easy stuff) but nothing of any real use to my current
problem.
If anyone has done any work on this front previously, and has results to
publish, I'd be grateful!
Cheers,
Norm.
Cheers,
Norm.
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.