7 Replies Latest reply: Oct 18, 2012 8:58 AM by Harshakb RSS

    Objects are missing after FULL export/Import

    178210
      AS part of E-bus 11.5.10.2 migration from HPTru64 to SunSolaris SPARC64, I have completed FULL database export/import as per metalink note#362205.1

      Objects are missing after import....what could be the reason?

      Number of Objects are missing
      ===================
      CTXSYS -- 52
      DBSNMP -- 4
      GL -- 1896
      MDSYS -- 36
      XDB -- 3

      Export Parfile
      =========

      directory=dmpdir
      dumpfile=aexp%U.dmp
      filesize=1048576000
      full=y
      exclude=SCHEMA:"='MDDATA'"
      exclude=SCHEMA:"='OLAPSYS'"
      exclude=SCHEMA:"='ORDSYS'"
      exclude=SCHEMA:"='DMSYS'"
      exclude=SCHEMA:"='OUTLN'"
      exclude=SCHEMA:"='ORDPLUGINS'"
      #transform=oid:n
      logfile=expdpapps.log


      Import Parfile
      ========

      directory=dmpdir
      dumpfile=aexp%U.dmp
      full=y
      transform=oid:n
      logfile=impdpapps.log