impdp is taking long time to complete over 3 days and not complete 80gb database. 11gr2 11.2.0.3
I am trying to migrate ebs 11i database from windows 32 bit to solaris 11 64 bit
when i run impdp "'/ as sysdba" parfile=axd.dat
parameter file.
#$Header: auexpdp.dat 115.4 2005/12/20 16:02:25 apydimar noship $
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=impdpapps.log
hanging at
orauat@ebsdevap:~/expimp$ tail impdpapps.log
. . imported "ZPB"."ZPB_STATUS_SQL" 0 KB 0 rows
. . imported "ZPB"."ZPB_TASK_PARAMETERS" 0 KB 0 rows
. . imported "ZPB"."ZPB_UNIV_ATTRIBUTES" 0 KB 0 rows
. . imported "ZPB"."ZPB_UNIV_DIMENSIONS" 0 KB 0 rows
when i run impdp "'/ as sysdba" parfile=axd.dat
parameter file.
#$Header: auexpdp.dat 115.4 2005/12/20 16:02:25 apydimar noship $
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=impdpapps.log
hanging at
orauat@ebsdevap:~/expimp$ tail impdpapps.log
. . imported "ZPB"."ZPB_STATUS_SQL" 0 KB 0 rows
. . imported "ZPB"."ZPB_TASK_PARAMETERS" 0 KB 0 rows
. . imported "ZPB"."ZPB_UNIV_ATTRIBUTES" 0 KB 0 rows
. . imported "ZPB"."ZPB_UNIV_DIMENSIONS" 0 KB 0 rows
0