This content has been marked as final. Show 3 replies
Pl post exact OS and database versions on source and target. If you use expdp instead of exp. you can use the SCHEMAS parameter in the import to limit what schemas to import.
Optionally, you can pre-create users and tablespaces if you want to change the name and sizing spcecifications on the tablespaces.
target : 18.104.22.168.0
3)will other default schemas override if we give full=y option while import.
Pl elaborate on what "default schemas" you are referring to. If you perform a full export using expdp, certain seeded schemas such as CTXSYS, ORDSYS and MDSYS are not exported.
Schemas CTXSYS MDSYS ORDSYS Are Not Exported [ID 228482.1]