ORA-31655 ORA-39154

Posted on by Leave a comment
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.

tagged with

Leave a Reply

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

Gravatar
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 )

Cancel

Connecting to %s