IMPDP does not import table, error ORA-31693: & ORA-00942:
I ran a impdp with my standard parameters and I received these messages for multiple tables.
ORA-31693: Table data object "schema"."table_name" failed to load/unload and is being skipped due to error:
ORA-00942: table or view does not exist
The log from the expdp shows that the tables were exported and when I ran the impdp to extract the ddl statements the code is there to create the tables that were reported as missing.
Here is my impdp command:
impdp dest_owner/dest_owner@dest_db dumpfile=source_data.dmp exclude=ROLE,STATISTICS job_name=dest_owner schemas=srce_schema REMAP_SCHEMA=seniordb:dest_owner table_exists_action=replace version=latest logfile=dest_owner.log TRANSFORM=OID:N