ORA-39171: Job is experiencing a resumable wait.
Together with
ORA-01653: Unable to extend table %s.%s by %s in tablespace %s
Or
ORA-01691 unable to extend lob segment string.string by string in tablespace string
Steps to follows:
1. Check the data files details of the tablespace
select * from dba_data_files where tablespace_name='TABLESPACE_NAME';
2. Data Pump Restart Capability:
1) In the IMPDP window, click CTRL-C to stop the job.
2) In the command line type:
Import> stop_job=immediate
3)Use SQLPlUS to make the required changes to the table space.
a) Add DataFile
ALTER TABLESPACE ADD DATAFILE ' ' SIZE M;
b) Resize the Datafile:
ALTER DATABASE DATAFILE ' ' RESIZE M;
c) Enable autoextend:
ALTER DATABASE DATAFILE ' ' AUTOEXTEND ON MAXSIZE UNLIMITED;
4) Attach the Job.
impdp system/manager attach=Job_Name
If you did not provide a specific job name when you first ran the IMPDP, Oracle will assign a default name for it. In order to find the System assigned name for the IMPDP job you can run the following query:
SELECT * FROM DBA_DATAPUMP_JOBS;
The result will probably be something like SYS_IMPORT_FULL_number.
5) Restart the job
Import> start_job
6) You can check the status of the job by simply typing STATUS in the utility
command prompt.
Import> status
