Oracle Data Pump Import imports no records When we do an Oracle Data Pump import of our database, it runs without significant errors.  However, on one table Oracle reports that 0 records have been imported.

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
. . imported "SCHEMA1"."TABLE_NAME"                   34.26 GB       0 out of 402776 rows


The import does create the table.  It just does not import any rows.  There are other miscellaneous errors during the import -- none of which apply to this table.

If we drop the table and do a table-level import, it again creates the table but imports 0 rows.

We are using a basic data pump command line.

userid="sys/********@INSTANCE AS SYSDBA" SCHEMAS=(SCHEMA1, SCHEMA2, ...) DIRECTORY=DPUMP_DIR LOGFILE=LOGFILE.IMP.LOG DUMPFILE=DUMPFILE_%U_DATE.dmpdp 


We are trying to figure out why the rows are not being loaded and to get them loaded.
I suspect this may have something to do with you starting impdp as sysdba. Please see the note in http://docs.oracle.com/database/121/SUTIL/dp_export.htm#SUTIL824:

"Do not start Export as SYSDBA, except at the request of Oracle technical support. SYSDBA is used internally and has specialized functions; its behavior is not the same as for general users."

Try your command as system.