I'm facing the below error in RWB, communication channel, did any one face the this error before, Please guide me about this
Database-level error reported by JDBC driver while executing statement 'SELECT DISTINCT I., M.PC_DESCRIPTION FROM PS_BUD_PROJECTS_INTF I, PS_BUD_PROJECTS_EST_INTF M where i.work_order_number = m.work_order_number and i.work_order_number in (select x.work_order_number from (SELECT DISTINCT H.WORK_ORDER_NUMBER from PS_BUD_PROJECTS_INTF H WHERE (H.SAP_PROC_STATUS IS NULL OR H.SAP_PROC_STATUS != 'X') AND H.WORK_ORDER_NUMBER IN (SELECT DISTINCT T.WORK_ORDER_NUMBER FROM PS_BUD_PROJECTS_INTF T,PS_BUD_PROJECTS_EST_INTF S WHERE T.WORK_ORDER_NUMBER = S.WORK_ORDER_NUMBER)) x where rownum < 1000)'. The JDBC driver returned the following error message: 'java.sql.SQLException: ORA-01652: unable to extend temp segment by 25 in tablespace TEMP '. For details, contact your database server vendor.*
Any ideas would be appreciated. Thanks.