Originally posted by pando
do you use that for temporary tablespace?

do you rebuild index to that tablespace?

do you move tables to that tablespace?
No. Users temporary tablespace designated as TEMP.
No. No rebuilding indexes
No. not moving any tables.

But I extracted one particular query during the error which is

SELECT /*+ ordered USE_NL(PIR_DATES_TXN) USE_NL(b) INDEX(GL_AUDIT_TXN
XFR_GLAUDIT_TXN_REF_NMBR) */ ......

could that be causing?

Thanks In Advance.