Stephane,
pdqout does give me a real good impression, not only the speed but also the
interface. I can see it uses parallel query. However, I, as a production
DBA, intend to change the application which come from a third party as a
package as small as possible. It takes 4hours to extract data at
Stephane,
pdqout does give me a real good impression, not
only the speed but also the
interface. I can see it uses parallel query.
However, I, as a production
DBA, intend to change the application which come
from a third party as a
package as small as possible. It takes 4hours to
extract data
As somebody who has insider's knowledge of pdqout and a decent understanding of exp
and SQL*Plus, I think that you must have a good number of numbers and dates in your
data. Both types (as opposed to strings) require conversion. Which is why exp, which
dumps bytes 'as is', can be so fast -