This discussion is archived
7 Replies Latest reply: Oct 18, 2012 6:58 AM by Harshakb RSS

Objects are missing after FULL export/Import

178210 Newbie
Currently Being Moderated
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

Legend

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