Friday, March 30, 2018

impdp hang

If your impdp hangs....
I use ctrl-c.
status ....
somestate returns
status ....
somestate returns again unchanged.
don't do kill_job !
don't do stop_job !
But look in the view dba_resumable......
There it is : unable to extend tablespace x or tablespace temp...
Alter database datafile 'x' autoextend on maxsize 64G ;
in impdp prompt you can now enter CONTINUE_CLIENT.
The output will continue again.
And in the best case your import will continue.


Happy Easter !


Dik



No comments: