I would like to migrate few dbs from OS HP-UX IA64 and oracle version 126.96.36.199 to Linux RHEL64 with oracle 188.8.131.52 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 184.108.40.206 to 220.127.116.11 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?
Thanks for sharing your experiences.
Edited by: user13377699 on Jan 2, 2013 5:21 AM
I would also suggest you apply the latest PSU patch (currently 18.104.22.168.4) to the target before you perform the import.
Quick Reference to RDBMS Database Patchset Patch Numbers [ID 753736.1]
Yes, you can perform a full import without having to use the EXCLUDE clause. Pl see the steps in the documentation
Expdp will not export schemas such as SYS, ORDSYS, MDSYS etc - http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_export.htm#i1006790
You do not have to re-run the catalog scripts after the import.