ORA-39171: Job is experiencing a resumable wait.
Together withORA-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 tablespace2. Data Pump Restart Capability:
select * from dba_data_files where tablespace_name='TABLESPACE_NAME';
1) In the IMPDP window, click CTRL-C to stop the job.
2) In the command line type:3)Use SQLPlUS to make the required changes to the table space.
Import> stop_job=immediate
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.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:
impdp system/manager attach=Job_Name
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