ORA-31655 or ORA-3915 error during IMPDP

Expdp Backup

Expdp backup is the logical backup. It will take out the ddl commands and data from the tables.

It is highly used backup.

When you got the following error, its means you are running taking backup of that user which is not exists in current database when you try to import this expdp will generate the following error:

ORA-31655: no data or metadata objects selected for job

ORA-39154: Objects from foreign schemas have been removed from import


You need to import the object of that schema into another schema. For this you need to use additional parameter in expdp command remap_schema-<oldschemaname>:<newschemaname>

<oldschemaname> means from which schema backup is taken.

<newschemaname> means inwhich you need to insert the data.

Use remap schema and import with sys or system user;

impdp directory=dbbackup remap_schema=scott:remap_test dumpfile=expdump.dmp logfile=impdump.log

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 )

Google photo

You are commenting using your Google 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

This site uses Akismet to reduce spam. Learn how your comment data is processed.