This discussion is archived
2 Replies Latest reply: Dec 2, 2013 8:25 AM by OracleBarista RSS

impdp imported several MB but still 0 out of Nn million rows?!?

OracleBarista Newbie
Currently Being Moderated

Thank you in advance for looking into this.  I look forward to any help and insight you may be able to provide.

 

Has anyone run into this issue when data pump shows "nMB but 0 out of millions of rows" NOT imported?!?  There are two tables in my import that do this.  I have also encountered this error as well  ORA-39166: Object was not found.  Which seemed to be circumvented ONLY after setting the characterset.  But now it cannot import data for two tables.

 

 

Here is the background.

The import was sent to me in two files.  The ddl in one dump and the data in another.  So I had to first create the DDL then import the data.

 

Create the ddl parameterfile and import the metadata.

------------------------------------------

Found the tablespaces from the source db.

I created a ddl file via impdp. remapped the tablespaces, created the users.

 

Import the data.

-----------------------------------------

I set the character set env variable and used the following settings in the parameter file.

 

CONTENT=all

DUMPFILE=DATA_PUMP_DIR:FILE.%U.dmp

LOGFILE=DATA_FILE_DIR:FILE_20131126.log

ENCRYPTION_PASSWORD='PASSWORD'

REMAP_SCHEMA=SCHEMA1:SCHEMA

JOB_NAME=SCHEMA_NAME

table_exists_action=append

FULL=N

PARALLEL=9

 

So I begin the import and this is the result :  (more than one table is not importing I showed two importing in my example however.)

 

. . imported "SCHEMA"."TABLE_01":"SYS_P597103"      663.4 MB       0 out of 32084160 rows

. . imported "SCHEMA"."TABLE_01":"SYS_P434333"      589.0 MB       0 out of 29672535 rows

. . imported "SCHEMA"."TABLE_01":"SYS_P635480"      656.6 MB       0 out of 32553771 rows

. . imported "SCHEMA"."TABLE_01":"SYS_P651574"      658.8 MB       0 out of 32960374 rows

. . imported "SCHEMA"."TABLE_01":"SYS_P460604"      626.5 MB       0 out of 30213168 rows

. . imported "SCHEMA"."TABLE_01":"SYS_P567240"      620.5 MB       0 out of 31071412 rows

. . imported "SCHEMA"."TABLE_01":"SYS_P577162"      633.1 MB       0 out of 31488125 rows

. . imported "SCHEMA"."TABLE_01":"SYS_P387361"      583.8 MB       0 out of 28632631 rows

. . imported "SCHEMA"."TABLE_01":"SYS_P402882"      592.3 MB       0 out of 28999710 rows

. . imported "SCHEMA"."TABLE_01":"SYS_P542284"      606.3 MB       0 out of 30659587 rows

. . imported "SCHEMA"."TABLE_01":"SYS_P366463"      567.9 MB       0 out of 27642766 rows

. . imported "SCHEMA"."TABLE_01":"SYS_P377498"      571.3 MB       0 out of 28178251 rows

. . imported "SCHEMA"."TABLE_01":"SYS_P339562"      608.0 MB       0 out of 26744122 rows

. . imported "SCHEMA"."TABLE_01":"SYS_P357772"      622.4 MB       0 out of 27225225 rows

. . imported "SCHEMA"."TABLE_02":"SYS_P578321"  234.1 MB 24498143 rows

. . imported "SCHEMA"."TABLE_02":"SYS_P578324"  240.2 MB 24498143 rows

. . imported "SCHEMA"."TABLE_01":"SYS_P192761"      449.9 MB       0 out of 21476694 rows

. . imported "SCHEMA"."TABLE_01":"SYS_P287781"      545.0 MB       0 out of 25607178 rows

. . imported "SCHEMA"."TABLE_01":"SYS_P336096"      558.2 MB       0 out of 26321351 rows

. . imported "SCHEMA"."TABLE_02":"SYS_P593408"  235.8 MB 24863112 rows

. . imported "SCHEMA"."TABLE_02":"SYS_P593423"  241.7 MB 24863112 rows

. . imported "SCHEMA"."TABLE_02":"SYS_P623103"  241.4 MB 25219732 rows

. . imported "SCHEMA"."TABLE_02":"SYS_P623104"  247.3 MB 25219732 rows

. . imported "SCHEMA"."TABLE_02":"SYS_P647262"  245.2 MB 25629915 rows

. . imported "SCHEMA"."TABLE_02":"SYS_P647342"  250.4 MB 25629915 rows

. . imported "SCHEMA"."TABLE_02":"SYS_P519883"  233.9 MB 23413438 rows

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points