Re: Fast impdp in 10.2.0.4

  • From: "sol beach" <sol.beach@xxxxxxxxx>
  • To: finn.oracledba@xxxxxxxxx
  • Date: Wed, 16 Apr 2008 19:15:34 -0700

I don't recall if it was on this list or some other, but impdp has a bug in
later V10 versions
where UTF8 data gets mangled. IIRC - the data is no longer recoverable.

So use impdp at your own discretion!

On Wed, Apr 16, 2008 at 9:36 AM, Finn Jorgensen <finn.oracledba@xxxxxxxxx>
wrote:

> Did anybody try large imports using impdp in 10.2.0.4 yet and noticed a
> big difference from 10.2.0.3?
>
> My environment is RHEL 4 upgraded from 10.2.0.3 to 10.2.0.4 on SAN RAID 5
> disks (don't ask) using veritas filesystems.
>
> I have had a regular data refresh going for some time now and the import
> time has been reasonably consistent. For example one of the imports has been
> taking 2.5 hours and another 1 hour and 15 minutes.
>
> This past weekend the longer one took 20 minutes (most of it is a large
> BLOB) and the other one took 29 minutes.
>
> The only thing that changed was the upgrade.
>
> Anybody else have this experience?
>
> Finn
>
>

Other related posts: