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.