IMPDP - ORA-01555 ORA-22924 (snapshot Too Old) In 11.2.0.4 With PARALLEL=3 Or More And 10g Dumpfile (Doc ID 1628103.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

When attempting to import from an Export Data Pump dumpfile that was created in an Oracle10g database (e.g. 10.2.0.4), and which is imported into an 11.2.0.4 target database with PARALLEL more than 2, the following error occurs.

$ impdp system/manager directory=my_dir dumpfile=expdp_f.dmp logfile=impdp_f.log full=y parallel=3

Import: Release 11.2.0.4.0 - Production on Tue Jan 14 15:37:45 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01":  
system/******** directory=my_dir dumpfile=expdp_f.dmp logfile=impdp_f.log full=y parallel=3
...
. . imported "KTACTWEB"."LOG_PARTITION":"LOG_20080902"  97.33 MB  693074 rows
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.MOVE_DATA [TABLE_DATA:"KTACTWEB"."LOG_PARTITION":"LOG_20080826"]
SELECT flags, NVL(target_xml_clob,xml_clob) FROM "SYSTEM"."SYS_IMPORT_SCHEMA_01" WHERE  process_order = :1
ORA-01555: snapshot too old: rollback segment number  with name "" too small
ORA-22924: snapshot too old
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 9721
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x76ec08b38     21979  package body SYS.KUPW$WORKER
0x76ec08b38      9742  package body SYS.KUPW$WORKER
0x76ec08b38     16536  package body SYS.KUPW$WORKER
0x76ec08b38      4549  package body SYS.KUPW$WORKER
0x76ec08b38     10464  package body SYS.KUPW$WORKER
0x76ec08b38      1824  package body SYS.KUPW$WORKER
0x772904d70         2  anonymous block
. . imported "KTACTWEB"."HIST_ADRS"                    62.16 MB  749477 rows
...

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms