My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.