I would like to migrate few dbs from OS HP-UX IA64 and oracle version 18.104.22.168 to Linux RHEL64 with oracle 22.214.171.124 using expdp/impdp.
For now, the main steps i list are the following:
1) create an empty target db (with all the catalog, tbs needed) from the source init.ora configuration file.
2) expdp full the source
3) impdp full into the target
My questions are about the 3) point:
1) Can i import in FULL mode from 126.96.36.199 to 188.8.131.52 or do i have to use the Exclude clause to avoid to overwrite "Oracle system users"
(for example EXCLUDE=SCHEMA:\"IN\(\'SYS\',\'SQLTXPLAIN\',\'DIP\',\'ORACLE_OCM\',\'EXFSYS\',\'DBSNMP\',\'XDB\',\'SYSTEM\',\'WMSYS\',\'OUTLN\'\)\")?
2) If the impdp full is possible, do you have to re-run hte catalog scripts?