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.
Best Answer
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.