ORA-39171

I ran Data Pump for the first time in May this year. It displayed the following errors:

ORA-39171: Job is experiencing a resumable wait.

ORA-01691: unable to extend lob segment ANDREW.SYS_LOB0000069553C00045$$ by 128 in tablespace USERS

ORA-39171: Job is experiencing a resumable wait.

ORA-01691: unable to extend lob segment ANDREW.SYS_LOB0000069553C00045$$ by 128 in tablespace USERS

ORA-39171: Job is experiencing a resumable wait.

ORA-01691: unable to extend lob segment ANDREW.SYS_LOB0000069553C00045$$ by 128 in tablespace USERS

ORA-39171: Job is experiencing a resumable wait.

ORA-01691: unable to extend lob segment ANDREW.SYS_LOB0000069553C00045$$ by 128 in tablespace USERS

I’m not sure why this happened but I set the tablespace’s datafile to autoextensible:

SQL> alter database datafile

  2  'D:\ORACLE\11.2.0\ORADATA\MDMPROD\MDM_SYSTEM\USERS01.DBF'

  3  autoextend on;

 

Database altered.

 

SQL>

The Data Pump job then jumped back into action and finished soon after. At the end of the log file there was the following message, which must relate to the 4 failures above as no other errors were displayed while it was running:

Job "ANDREW"."SYS_EXPORT_FULL_01" completed with 4 error(s) at 15:43:25