ORA-39171: Job is experiencing a resumable wait.

ERROR CODE:

ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table
schema_name.Tablename by 8192 in tablespace AXPERT.

Reason:
              While Importing the backup file If you get above error that means That particular default Tablespace datafile is reached max size.In Oracle Database 11g version every individual data file  max size is 31 GB.


Solution :
                    You  should be added new datafile to Which is default Tablespace.

Check the Tablespace  Available space with below script :

select df.tablespace_name "Tablespace",
totalusedspace "Used MB",
(df.totalspace - tu.totalusedspace) "Free MB",
df.totalspace "Total MB",
round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace))
"Pct. Free"
from
(select tablespace_name,
round(sum(bytes) / 1048576) TotalSpace
from dba_data_files
group by tablespace_name) df,
(select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name
from dba_segments
group by tablespace_name) tu
where df.tablespace_name = tu.tablespace_name
and df.tablespace_name = 'AXPERT';

Tablespace                        Used MB    Free MB   Total MB  Pct. Free
------------------------------ ---------- ---------- ---------- ----------
AXPERT                             213829      10621     224450          5

Find the file name/location of your tablespace

SELECT file_name, tablespace_name FROM dba_data_files
where TABLESPACE_NAME = 'AXPERT';

FILE_NAME                                                                              TABLESPACE_NAME
-----------                                                                                      ---------------
F:\APP\ADMINISTRATOR\ORADATA\ORCL\AXPERT01.DBF    AXPERT

F:\APP\ADMINISTRATOR\ORADATA\ORCL\AXPERT02.DBF    AXPERT

F:\APP\ADMINISTRATOR\ORADATA\ORCL\AXPERT03.DBF    AXPERT

Increase the table space Size

ALTER DATABASE DATAFILE 'F:\APP\ADMINISTRATOR\ORADATA\ORCL\AXPERT03.DBF' RESIZE 5000M;

If above all Datafiles have max size then,

ALTER TABLESPACE AXPERT ADD DATAFILE 'F:\APP\ADMINISTRATOR\ORADATA\ORCL\AXPERT04.DBF' SIZE 1024M REUSE AUTOEXTEND ON MAXSIZE 10240M ;  (It will increase the size upto 10GB)

(OR) 

ALTER TABLESPACE AXPERT ADD DATAFILE 'F:\APP\ADMINISTRATOR\ORADATA\ORCL\AXPERT04.DBF' SIZE 1024M REUSE AUTOEXTEND ON; (It will increase upto 31GB)

Now start the fresh IMPDP job.

If you have comment/suggestion please post.