Instead of creating a full export data pump file, create an export for user schemas and import the schemas using the following example workflow:
- expdp directory=EXPDIR schemas=SDE,GIS,DATA_OWNER logfile=schema_expdp.log
- impdp directory=IMPDIR schemas=SDE logfile=sde_schema_impdp.log
- Recompile any invalid objects for the SDE schema.
- impdp directory=IMPDIR schemas=GIS,DATA_OWNER logfile=other_schemas_impdp.log