Hi,

Can you plz answer following quetions ?

1). I am migrating database from 10g to 11g from one host to another host

what parameters we should use in EXPDP, for better export?
why Iam asking is after migration ( import done ) I am missing some of the objects, I dont know why I am missing ?
2). what Parameter should use in IMPDP, for better import ?

why I am asking is I am gettimg below errors when I am importing,

ORA-39082: Object type PACKAGE_BODY:"LILLY_OWNER"."LILLY_SEQMOL2DKEYS$RP" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"LILLY_OWNER"."LILLY_STEREO$RP" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"LILLY_OWNER"."LILLY_SALTS$RP" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"LILLY_OWNER"."LILLY_FSIDX$RL" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"LILLY_OWNER"."LILLY_SAMID_READ_PKG" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"LILLY_OWNER"."LILLY_ENKFIL$RP" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"LILLY_OWNER"."LILLY_FSIDX$RP" created with compilation warnings

Please post your answers, and send me any links/materials for db migration .

Here I am pasting what parameters Iam using generally;

For EXPORT :
$ expdp parfile=export.par

export.par file Contains :

full=y
directory=dumpfiles1
dumpfile=CR06172102_%Uexport.dmp
logfile=CR06172102_export.log
job_name=CR06172102_export1
parallel=4
flashback_time = "to_timestamp(to_char(sysdate,'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS')"

For IMPORT:
$impdp parfile=import.par

import.par file contains :

full=y
directory=dump_files1
dumpfile=CR06172102_%Uexport.dmp
logfile=CR06172102_import.log
job_name=CR06172102_import
parallel=8
EXCLUDE=TABLESPACE
EXCLUDE=DIRECTORY
EXCLUDE=SCHEMA:"='TSMSYS'"
EXCLUDE=SCHEMA:"='SYS'"
EXCLUDE=SCHEMA:"='SYSTEM'"
EXCLUDE=SCHEMA:"='WMSYS'"
EXCLUDE=SCHEMA:"='DBSNMP'"
EXCLUDE=SCHEMA:"='OUTLN'"
EXCLUDE=SCHEMA:"='SYSMAN'"
EXCLUDE=SCHEMA:"='ANONYMOUS'"
EXCLUDE=SCHEMA:"='CTXSYS'"
EXCLUDE=SCHEMA:"='DIP'"
EXCLUDE=SCHEMA:"='ORAMAN'"
EXCLUDE=SCHEMA:"='XDB'"