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
