Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
dpimp problems
625 views
Skip to first unread message
dba cjb
Feb 15, 2012, 11:20:28 AM2/15/12
to
target 11g source 10g on windows 2008
I have been using dpimp generally working / tested with tables up to
250m working in seconds
I am importing into a 11g environment with a user specially created
I am sometimes getting blocked by wait events on source database
with control file parallel write or log file parallel write
So some tables work & others just cause the job to hang with sessions
in source database causing the above wait events.
Is there anyway I can set up my dpimp param file ( see below )to
avoid these
/ my instinct is that the fail is because of other parts of new
environment being missing ?
Should I turn parallel off or is this a red herring?
Any help will be gratefully ( in solution or approach) received as I
am near to my wit's end !!
Chris B
D:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN>impdp Cbrown/
password@BMIDW PA
RFILE=D:\DPWORKAREA\INCLUDEBROKERSAMPLE.PAR
TABLES=LIVE.DS_BROKER
REMAP_TABLESPACE=DSTDATAMED:CJBDATA
DIRECTORY=dpump_dir1
EXCLUDE=CONSTRAINT
EXCLUDE=REF_CONSTRAINT
EXCLUDE=PACKAGE
EXCLUDE=FUNCTION
EXCLUDE=PROCEDURE
EXCLUDE=INDEX
NETWORK_LINK=datapump
PARALLEL=4
I have been using dpimp generally working / tested with tables up to
250m working in seconds
I am importing into a 11g environment with a user specially created
I am sometimes getting blocked by wait events on source database
with control file parallel write or log file parallel write
So some tables work & others just cause the job to hang with sessions
in source database causing the above wait events.
Is there anyway I can set up my dpimp param file ( see below )to
avoid these
/ my instinct is that the fail is because of other parts of new
environment being missing ?
Should I turn parallel off or is this a red herring?
Any help will be gratefully ( in solution or approach) received as I
am near to my wit's end !!
Chris B
D:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN>impdp Cbrown/
password@BMIDW PA
RFILE=D:\DPWORKAREA\INCLUDEBROKERSAMPLE.PAR
TABLES=LIVE.DS_BROKER
REMAP_TABLESPACE=DSTDATAMED:CJBDATA
DIRECTORY=dpump_dir1
EXCLUDE=CONSTRAINT
EXCLUDE=REF_CONSTRAINT
EXCLUDE=PACKAGE
EXCLUDE=FUNCTION
EXCLUDE=PROCEDURE
EXCLUDE=INDEX
NETWORK_LINK=datapump
PARALLEL=4
onedbguru
Feb 17, 2012, 10:45:55 PM2/17/12
to
On Feb 15, 11:20 am, dba cjb <chris.br...@providentinsurance.co.uk>
wrote:
If you are using a network_link, I would disable parallel. It may
actually be faster to go to the source, expdp the user/schema, copy
the file to the target and import it. Based on your response file
here, I cannot determine what is your end goal, but it looks like you
just want one table copied to the new server. If that is the case,
then you may also want to create the table manually and use
CONTENT=DATA_ONLY.
wrote:
actually be faster to go to the source, expdp the user/schema, copy
the file to the target and import it. Based on your response file
here, I cannot determine what is your end goal, but it looks like you
just want one table copied to the new server. If that is the case,
then you may also want to create the table manually and use
CONTENT=DATA_ONLY.
0 new messages