ORA-31655 ORA-39154

While doing import using the impdp utility , I got the below errors

ORA-31655: no data or metadata objects selected for job
ORA-39154: Objects from foreign schemas have been removed from import

Solution :-

The DDL for the tables already exists. So to import only the data use CONTENT=DATA_ONLY in the impdp command.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s