Oracle IMPDP not importing rows

1.8k Views Asked by At

I am trying to import one table from a full DB export but the table I want will not import the rows. If I try another table then the rows import fine!

Using Oracle 11.2.0.4 in Windows 2008 R2

The export was successful :

Job "BKUP_USER"."EXPFULL" successfully completed at Wed Mar 28 11:25:10 2018 elapsed 0 00:54:55

And the import was also successful (from a logging point of view) :

;;; 
Import: Release 11.2.0.4.0 - Production on Wed Oct 10 12:37:58 2018

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
;;; 
Connected to: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
Master table "BKUP_USER"."IMPDOC" successfully loaded/unloaded
Starting "BKUP_USER"."IMPDOC":  bkup_user/******** parfile=ajrlead.par 
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
. . imported "ROBERTKING"."WWV_DOCUMENT$"                89.78 GB       0 out of 107278 rows
. . imported "ROBERTKING"."WWV_HELP$"                    689.4 KB     284 rows
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER
Job "BKUP_USER"."IMPDOC" successfully completed at Wed Oct 10 12:38:05 2018 elapsed 0 00:00:07

Just that it does not import the rows for the table I want!:

0 out of 107278 rows

My import parameter file :

SCHEMAS=e_agent_site
REMAP_SCHEMA=e_agent_site:robertking
DUMPFILE=AJRLEAD:FULL%U.dmp
LOGFILE=AJRLEAD:doc_restore.log
JOB_NAME=IMPDOC
TABLE_EXISTS_ACTION=APPEND
CONTENT=ALL
INCLUDE=TABLE:"IN ('WWV_HELP$', 'WWV_DOCUMENT$')"

I've some mentions around sysdba causing issues, the file was not exported using sysdba but I have trued running the import as sys as sysdba and get the same issue

Any ideas???

0

There are 0 best solutions below