User Jobs Are Appearing Under System Schema Ownership after IMPORT or IMPDP
(Doc ID 831154.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Server - Enterprise Edition - Version: 188.8.131.52 to 10.2.0.4
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.4
This problem can occur on any platform.
Exports from 9i and import into 10g
After a FULL or SCHEMA level export from a 9i release Oracle database database you find some jobs changing ownership to the SYSTEM schema if importing into a 10g database.
Datapump Expdp and Impdp (10g)
After a FULL or SCHEMA level exp[dp] of a 10g database you imp[dp] selected SCHEMAs or FULL using the SYSTEM schema you find some JOBs have changed ownership to SYSTEM.
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