My Oracle Support Banner

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

Last updated on MAY 18, 2021

Applies to:

Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version to [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.


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

$ impdp <LOGIN>/<PASSWORD> directory=my_dir dumpfile=expdp_f.dmp logfile=impdp_f.log full=y parallel=3

Import: Release - 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 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options
Master table "<SCHEMA_NAME>"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
<LOGIN>/******** directory=my_dir dumpfile=expdp_f.dmp logfile=impdp_f.log full=y parallel=3
. . imported "<SCHEMA_NAME>"."<TABLE_NAME>":"<PARTITION_NAME>" 97.33 MB  693074 rows
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.MOVE_DATA [TABLE_DATA:"<SCHEMA_NAME>"."<TABLE_NAME>":"<PARTITION_NAME>"]
SELECT flags, NVL(target_xml_clob,xml_clob) FROM "<SCHEMA_NAME>"."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 "<SCHEMA_NAME>"."<TABLE_NAME>"                    62.16 MB  749477 rows





To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.