2 Replies Latest reply: Jan 2, 2013 9:32 AM by user13377699 RSS

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

    user13377699
      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