Error: QO_SAVE_OUTPUT_RECS returned: ORA-01652: unable to extend temp - when running Query and Output Processing

The Query and Output Processing fails with the following error (as found in the Queue log):

Error: QO_SAVE_OUTPUT_RECS returned: ORA-01652: unable to extend temp
1) Check for missing indexes:

select * from dd_indexes i 
where not exists 
(select '1' from dba_indexes i2
where i.index_name = i2.index_name
and i.table_name = i2.table_name);

2) Is the query pulling more records than usual?

3) Has the client made any recent changes to the output?

Environment

 RSR
 TA

Was this article helpful?