Saturday, September 28, 2013

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