Impdp Doesn't Load Large Table Data - 0 Out Of 1268185777 Rows (Doc ID 1987476.1)

Last updated on MARCH 16, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

On 11.2.0.3 when importing 4 of the largest tables, the DataPump log reported 0 rows imported and no errors were raised.

This process of exporting and importing had worked fine in the past.

Master table "SYSTEM"."SYS_IMPORT_TABLE_06" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TABLE_06": system/********@ PARFILE=parfile.txt
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "DBO"."T_LIUD_USER_DEFINED_VARIABLE" 185.5 GB 0 out of 6,997,967,388 rows
. . imported "DBO"."T_LITD_TRANSACTION_DETAIL" 188.6 GB 0 out of 1,261,576,475 rows
. . imported "DBO"."T_LIGL_GENERAL_LEDGER" 171.1 GB 0 out of 2,228,112,482 rows
. . imported "DBO"."T_LIDV_DEPOSIT_VALUE" 45.58 GB 0 out of 1,160,818,356 rows


Export shows, the data was actually exported:

. . exported "DBO"."T_LIUD_USER_DEFINED_VARIABLE" 185.5 GB 6997967388 rows
. . exported "DBO"."T_LITD_TRANSACTION_DETAIL" 188.6 GB 1261576475 rows
. . exported "DBO"."T_LIGL_GENERAL_LEDGER" 171.1 GB 2228112482 rows
. . exported "DBO"."T_LIDV_DEPOSIT_VALUE" 45.58 GB 1160818356 rows

 

Changes

 The only change that occurred was that the size of the table increased.

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