Jobs In Incorrect Schema After Datapump Import (Doc ID 749170.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

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

ie:

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

Cause

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