I have a dump file which is taken from different database with DBA user. I am trying to import the same dump to different database with different user. Data Pump import job failed with following error.
ORA-31655: no data or metadata objects selected for job
ORA-39154: Objects from foreign schemas have been removed from import
It is the permission / privilege issue with the user which trying to import the dump. The user doesn’t have IMP_FULL_DATABASE privilege to import the dump. You have to grant above privilege to the user which will resolve the issue.
SQL> grant imp_full_database to mytest;