Jobs In Incorrect Schema After Datapump Import

(Doc ID 749170.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: to
This problem can occur on any platform.


After importing users using Datapump the jobs are not created with owner name but with a different user.


importing with user_A the schema user_A, the syntax would be something like:

   impdp user_A/password directory=DIR dumpfile=file.dp logfile=file.log include=job schemas=user_A

the job is created with different user;   user_B


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms