This discussion is archived
2 Replies Latest reply: Jan 2, 2013 7:32 AM by 802019 RSS

Moving/upg dbs from HP-UX IA64 (oracle 11.2.0.2) to Linux (oracle 11.2.0.3)

802019 Newbie
Currently Being Moderated
Hi,

I would like to migrate few dbs from OS HP-UX IA64 and oracle version 11.2.0.2 to Linux RHEL64 with oracle 11.2.0.3 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 11.2.0.2 to 11.2.0.3 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.
Nico.

Edited by: user13377699 on Jan 2, 2013 5:21 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points