Migrating 11.2.0.3 EE Single Instance DB to 19c EE Single Instance DB using DataPump
Migrating 11.2.0.3 EE Single Instance DB to 19c EE Single Instance DB using DataPump
Our approach is to take a full database export of a 11.2.0.3 EE DB and import to a 19c empty DB on a new server.
I have questions on the best/recommended approach.
(1) Since a full database EXPDP (FULL=Y) is being done - is it necessary to create the tablespace and users before importing the DB on the target server (the file system/mount points/allocated space are identical on source and target)?
(2) What DB components are not created in the full export (e.g. non-default profiles, roles, role_grant, users, etc.)? (I realize grants on objects owned by the SYS schema are never exported and public synonyms/DB Links should be applied after the import on the target is completed.)