Database Utilities (MOSC)

MOSC Banner

IMPDP does not import table, error ORA-31693: & ORA-00942:

edited May 27, 2010 9:46AM in Database Utilities (MOSC) 2 commentsAnswered
 Hello,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center