RE: Expdp a subset of fields from a table
From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Mon, 29 Jun 2009 13:03:17 -0400
Message-ID: <BAY115-DAV55CB059CC1CCE9D8DD751A6300_at_phx.gbl>
Message-ID: <45928F433DAA4A60A31C71F334E07053_at_vpmcm01>
What do you mean by 'We are trying to prove expdp is having an issue with just the LOB data of a business table' any ora- errors.
Date: Mon, 29 Jun 2009 13:03:17 -0400
Message-ID: <BAY115-DAV55CB059CC1CCE9D8DD751A6300_at_phx.gbl>
Message-ID: <45928F433DAA4A60A31C71F334E07053_at_vpmcm01>
What do you mean by 'We are trying to prove expdp is having an issue with just the LOB data of a business table' any ora- errors.
I've found that it doesn't matter if you use expdp or exp, exporting lob is always extremely slow. Our lobs are xmltype and have a lot of info in them.
We are trying to prove expdp is having an issue with just the LOB data of a business table - we have already checked for corruption.
Thanks,
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 29 2009 - 12:03:17 CDT