No question at this time
DBA Top 10
1 M. Cadot 23300
2 A. Kavsek 15200
3 M. Hidayathullah ... 11000
4 B. Vroman 8300
5 P. Wisse 6000
6 T. Boles 5000
7 J. Schnackenberg 3800
8 G. Lambregts 2200
8 P. Knibbs 2200
10 K. Van Nieuwenhov... 2100
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48039
Total active users1770
Act. users last 24h10
Act. users last hour1
Registered user hits last week205
Registered user hits last month1405
Go up

IMPDP seems to be stuck
Next thread: rollback not completed
Prev thread: network adapter issues

Message Score Author Date
Hi Gurus , I am importing one table (800 Gb) into...... Sandeep Negi Jul 11, 2017, 13:55
You might check the long_ops / wait of the impdp w...... Rob Pattyn Jul 11, 2017, 16:24
Hello Sandeep, are you importing in an interact...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Bruno Vroman Jul 11, 2017, 18:32
You can use McDP to follow your import: http://...... Score: 700 PtsScore: 700 PtsScore: 700 PtsScore: 700 PtsScore: 700 Pts Michel Cadot Jul 11, 2017, 19:25
Hi All, Thanks all for you updates. Still im...... Sandeep Negi Jul 12, 2017, 07:26
As I said, you can get the full status of your i...... Michel Cadot Jul 12, 2017, 08:06
Hi Gurus , Please advise , impdp completed wit...... Sandeep Negi Jul 15, 2017, 06:45
I suggest you import also the parent table and i...... Michel Cadot Jul 15, 2017, 07:43
Another suggestion is to import without the cons...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Michel Cadot Jul 15, 2017, 07:51
In the end, I suggest you feedback, thank and ra...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Michel Cadot Jul 15, 2017, 07:53
Thanks Michel, Previously I stopped the IMPMP j...... Sandeep Negi Jul 15, 2017, 08:24
Hi All, Thanks for your update . As there is huge...... Sandeep Negi Jul 15, 2017, 15:16
Hello, I assume that checkin_date is a date (yo...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Bruno Vroman Jul 17, 2017, 09:35
Thanks Bruno, Query command worked using the pa...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Sandeep Negi Jul 17, 2017, 10:17

Follow up by mail Click here


Subject: IMPDP seems to be stuck
Author: Sandeep Negi, India
Date: Jul 11, 2017, 13:55, 71 days ago
Os info: Solaris SSC 11.3
Message: Hi Gurus ,
I am importing one table (800 Gb) into my database. When I am checking the size of the tablespace , its stuck in 300 gb. How I can check my impdp is running fine. I checked through sql and impdp job is in executing state.

Please let me know , is my impdp stuck.
why the size of the tablespace not increasing.

What the next action plan I an follow for successful import.

There is no error in impdp logfile not yet failed.

Thanks

Please provide your opinion as import is on production database.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: IMPDP seems to be stuck
Author: Rob Pattyn, Belgium
Date: Jul 11, 2017, 16:24, 71 days ago
Message: You might check the long_ops / wait of the impdp worker session
http://oradbatips.blogspot.be/2010/09/tip-89-progress-of-datapump-import-with.html
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: IMPDP seems to be stuck
Author: Bruno Vroman, Belgium
Date: Jul 11, 2017, 18:32, 71 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hello Sandeep,

are you importing in an interactive session? If yes, no message on screen?
Maybe the import is suspended (in "resumable state") because of a space issue... (well, if this was the case I guess it is too late now)?
Is the relevant tablespace able to grow? (autoextend on, next, maxsize, number of datafiles, ...)
Is there space at OS level?
And what about the alert logfile?

Best regards,

Bruno Vroman.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: IMPDP seems to be stuck
Author: Michel Cadot, France
Date: Jul 11, 2017, 19:25, 71 days ago
Score:   Score: 700 PtsScore: 700 PtsScore: 700 PtsScore: 700 PtsScore: 700 Pts
Message:
You can use McDP to follow your import:
http://www.orafaq.com/forum/t/201760/

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: IMPDP seems to be stuck
Author: Sandeep Negi, India
Date: Jul 12, 2017, 07:26, 71 days ago
Message: Hi All,

Thanks all for you updates.

Still impdp is in executing state and no errors in the log file.
FYI , once we killed the impdp job and started again and showing 300 Gb only.
Please suggest , shall I wait for the IMPDP to fail.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: IMPDP seems to be stuck
Author: Michel Cadot, France
Date: Jul 12, 2017, 08:06, 71 days ago
Message:
As I said, you can get the full status of your import using McDP.
So I suggest you to do it now.

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: IMPDP seems to be stuck
Author: Sandeep Negi, India
Date: Jul 15, 2017, 06:45, 68 days ago
Message: Hi Gurus ,

Please advise , impdp completed with error and blob data not accessible.

Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_TABLE_01": /******** AS SYSDBA TABLES=afm.AFM_DOCVERS CONTENT=data_only dumpfile=AFM_DOCVERS20170607.DMP directory=CAFMIMPORT logfile=afm_docovers_import.log
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-31693: Table data object "AFM"."AFM_DOCVERS" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-02291: integrity constraint (AFM.AFM_DOCVERS_PKEY_VALUE_1) violated - parent key not found
Job "SYS"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at Sat Jul 15 06:34:54 2017 elapsed 3 13:42:12

Please suggest .
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: IMPDP seems to be stuck
Author: Michel Cadot, France
Date: Jul 15, 2017, 07:43, 68 days ago
Message:
I suggest you import also the parent table and its data.

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: IMPDP seems to be stuck
Author: Michel Cadot, France
Date: Jul 15, 2017, 07:51, 68 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message:
Another suggestion is to import without the constraint.

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: IMPDP seems to be stuck
Author: Michel Cadot, France
Date: Jul 15, 2017, 07:53, 68 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message:
In the end, I suggest you feedback, thank and rate people that take time to (try to) help you.
For instance, we can now see your import no more "hang", what was the original problem? How did you diagnose it? How did you solve it?

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: IMPDP seems to be stuck
Author: Sandeep Negi, India
Date: Jul 15, 2017, 08:24, 68 days ago
Message: Thanks Michel,

Previously I stopped the IMPMP jobs and killed.
Retried IMPDP again and it completed but with errors.

Thanks all for providing their valuable feedback.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: IMPDP seems to be stuck
Author: Sandeep Negi, India
Date: Jul 15, 2017, 15:16, 67 days ago
Message: Hi All, Thanks for your update .
As there is huge dependency of this system so we are planning to import AFM_DOCVERS in parts and import AFM_DOCVERS in batches

Batch 1 – specific day 22 Nov 2010 for testing

To Import we are executing following query

impdp TABLES=afm.AFM_DOCVERS CONTENT=data_only dumpfile=AFM_DOCVERS_20170420.DMP directory=CAFMIMPORT_DOC logfile=afm_docovers_01JAN2012.log query=afm.AFM_DOCVERS:\"where checkin_date='22-NOV-10'\"

Please suggest the actual command.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: IMPDP seems to be stuck
Author: Bruno Vroman, Belgium
Date: Jul 17, 2017, 09:35, 66 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hello,

I assume that checkin_date is a date (you should not compare it to a string) and that the part "HH24:MI:SS" is always equal to 00:00:00 by design, hence it can make sense to ask "checkin_Date = TO_DATE( '2010-11-22', 'YYYY-MM-DD' )"
Otherwise, if there might be "hour:mi:sec", what you want is probably: checkin_date >= DATE '2010-11-22' AND checkin_date < DATE '2010-11-23'

I suggest you to use a parameter file to have less constraints with single quotes double quotes backslashes...

Best regards,

Bruno.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: IMPDP seems to be stuck
Author: Sandeep Negi, India
Date: Jul 17, 2017, 10:17, 66 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Thanks Bruno,

Query command worked using the par file. Even importing between date ranges consuming more time. We are exporting through SQl developer and importing dump . Its fast and we imported 6 month data in less than 6 hours and user are able to access the blob data.

Thanks all for your support.


Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here