We help IT Professionals succeed at work.

impdp stucked

dba1234
dba1234 asked
on
Hi guys,
I am importing one table with the help of impdp
but It got stucked every time for 1hr. I have tried 3-4 times.


impdp  directory=DATA_PUMP_DIR dumpfile=table.dmp logfile=table.log tables=stagingdata.ST_MHS_ENRLM content=data_only
Comment
Watch Question

SILVER EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
Define stuck.  How do you know it wasn't doing anything?

How long do you think it should take?
What is the size of the table?
What types of indexes/constraints are on the table?

Author

Commented:
I waited for more than one hour.
The size of the table is 2.5 GB.
I have disabled all the constriants and It has bitmap, btree and unique indexes.
SILVER EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
>>I waited for more than one hour.

How do you know it wasn't doing anything?
How long do you think it should take?

Author

Commented:
I am not sure how long it should take , usually it takes 5-10 minutes.
SILVER EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
5-10 minutes for the same 2.5 gig table or is this different somehow?

Please try to answer all the questions at once.  It saves me from repeating them:
How do you know it wasn't doing anything?


Author

Commented:
It was at the same line from last one hr when I terminated the job. So I thinked that It got stucked.


Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "harry"."SYS_IMPORT_TABLE_04" successfully loaded/unloaded
Starting "harry"."SYS_IMPORT_TABLE_04":  harry/******** directory=DATA_PUMP_DIR dumpfile=table.dmp logfile=table.log tables=stagingdata.ST_MHS_ENRLM content=data_only
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
SILVER EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
We are having a communication issue.

You said it normally takes 5-10 minutes.  So, you have run this before and are used to running it.

Is it always 2.5 Gig when you have run it before or has it suddenly changed in size?

I still do not see an answer to this so I will REPEAT it one last time:
How do you know it wasn't doing anything?



If you do not answer the questions I ask, I'll need to stop responding and let some other Experts help you.

I'm asking these question in an attempt to diagnose the issue.  If you do not answer them, I cannot help.

Author

Commented:
when I was checking the status in the impdp help. I got status 100% completed but when I check data.
I could not find any thing this way I was thinking It got stucked.
SILVER EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
I'm not finding anything that would cause this.

I'm also not an expert on the new datapump utilities.  I was thinking that maybe indexes/constraints were being rebuilt and you could see some disk/cpu activity.

I would probably contact Oracle Support to see it the import is truly hung or if the 100% status isn't really 100%.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.