This content has been marked as final. Show 2 replies
Pl post details of exact versions of "10g", "11gR2" and OS on both source and target, along with the complete export command syntax that was used.1 person found this helpful
Why not perform a full import on the target in one-step ?
how can I import roles/users in 11g(second db) without sys,sysman,system etc users, by Oracle Data Pump?SYS Objects are not exported by DATAPUMP:
A number of system schemas cannot be exported because they are not user schemas; they contain Oracle-managed data and metadata. Examples of system schemas that are not exported include SYS, ORDSYS, and MDSYS.
However, SYSMAN is exported by DATAPUMP.
So if you intend to select the Schemas you intend to Export/Import you may use the SCHEMAS parameter.
Also, it's possible to select the Object Type you want (or not) by using the INCLUDE/EXCLUDE Parameter.
You'll have some examples below:
Hope this help.