ORA-39912: Dependent object type Table: User5.Employee skipped, base object type creation failed

Error: while Impdp datapump job, we are continue getting error and our import process is running from long durations.

ORA-39912: Dependent object type Table: User5.Employee skipped, base object type creation failed.

Cause: We executed the job for the one schema to remap it into another schema but its running for all schema present in dump. Job command for impdp as:

impdp remap_schema=user1:usertest remap_tablespace=user_tb1:users DIRECTORY=backup_dir  DUMPFILE=userall.dmp   LOGFILE=user_imp.log

Solution: It running since long for all user and throwing error for other user. we skipped to add schemas parameter. so that it will work only for specific user. we modified the above command and add the schemas parameter in it.

impdp schemas=user1 remap_schema=user1:usertest remap_tablespace=user_tb1:users DIRECTORY=backup_dir  DUMPFILE=userall.dmp   LOGFILE=user_imp.log

Now the Impdp command work only for user USER1.