Untitled

### Error querying database.  Cause: java.sql.SQLException: ORA-01652: невозможно увеличить временный сегмент до 128 в разделе TEMP

### The error may exist in com/peterservice/scc/cp/workers/mybatis/FixedSubscribersServicesMapper.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: with main_services as ( /*основные услуги фиксированной связи - входящие в состав групп*/       select sbo.obj_id1, sbotg.sbog_sbog_id from sc_business_objects sbo         join sc_business_obj_to_groups sbotg on sbotg.sbo_sbo_id = sbo.sbo_id and sbo.sbot_sbot_id = 3     ),     fixed_subscribers as ( /*абоненты фиксированной связи*/       select distinct subs_id       from subscribers s         inner join client_histories ch on ch.clnt_clnt_id = s.clnt_clnt_id and s.sbst_sbst_id in (2, 3)         inner join subs_histories sshs on s.subs_id = sshs.subs_subs_id and sshs.start_date < sysdate  and sysdate <= sshs.end_date and scx_cp_b2b_portal_conditions.get_service_type_id(ch.clnt_clnt_id, ch.ctyp_ctyp_id, ch.clcl_clcl_id, ch.brnc_brnc_id, s.subs_id, s.stnd_stnd_id, sshs.rtpl_rtpl_id) = 2 /* Тип связи (2 - фиксированная) */     )     select       fs.subs_id as SUBS_ID, sh.srls_srls_id as SERVICE_ID     from fixed_subscribers fs       left join serv_histories sh on sh.subs_subs_id = fs.subs_id and sh.start_date < sysdate and sysdate <= sh.end_date       inner join main_services ms on sh.srls_srls_id = ms.obj_id1
### Cause: java.sql.SQLException: ORA-01652: невозможно увеличить временный сегмент до 128 в разделе TEMP

org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: java.sql.SQLException: ORA-01652: невозможно увеличить временный сегмент до 128 в разделе TEMP

### The error may exist in com/peterservice/scc/cp/workers/mybatis/FixedSubscribersServicesMapper.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: with main_services as ( /*основные услуги фиксированной связи - входящие в состав групп*/       select sbo.obj_id1, sbotg.sbog_sbog_id from sc_business_objects sbo         join sc_business_obj_to_groups sbotg on sbotg.sbo_sbo_id = sbo.sbo_id and sbo.sbot_sbot_id = 3     ),     fixed_subscribers as ( /*абоненты фиксированной связи*/       select distinct subs_id       from subscribers s         inner join client_histories ch on ch.clnt_clnt_id = s.clnt_clnt_id and s.sbst_sbst_id in (2, 3)         inner join subs_histories sshs on s.subs_id = sshs.subs_subs_id and sshs.start_date < sysdate  and sysdate <= sshs.end_date and scx_cp_b2b_portal_conditions.get_service_type_id(ch.clnt_clnt_id, ch.ctyp_ctyp_id, ch.clcl_clcl_id, ch.brnc_brnc_id, s.subs_id, s.stnd_stnd_id, sshs.rtpl_rtpl_id) = 2 /* Тип связи (2 - фиксированная) */     )     select       fs.subs_id as SUBS_ID, sh.srls_srls_id as SERVICE_ID     from fixed_subscribers fs       left join serv_histories sh on sh.subs_subs_id = fs.subs_id and sh.start_date < sysdate and sysdate <= sh.end_date       inner join main_services ms on sh.srls_srls_id = ms.obj_id1
### Cause: java.sql.SQLException: ORA-01652: невозможно увеличить временный сегмент до 128 в разделе TEMP

	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.select(DefaultSqlSession.java:172)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.select(DefaultSqlSession.java:158)
	at com.peterservice.scc.cp.workers.impl.MapperThread.loadDataDirectly(MapperThread.java:172)
	at com.peterservice.scc.cp.workers.impl.MapperThread.loadOneTable(MapperThread.java:105)
	at com.peterservice.scc.cp.workers.impl.MapperThread.call(MapperThread.java:210)
	at com.peterservice.scc.cp.workers.impl.MapperThread.call(MapperThread.java:30)
	at com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:108)
	at com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:41)
	at com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:77)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: ORA-01652: невозможно увеличить временный сегмент до 128 в разделе TEMP

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1281)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3685)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1376)
	at sun.reflect.GeneratedMethodAccessor114.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:230)
	at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:124)
	at com.sun.proxy.$Proxy258.execute(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor114.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
	at com.sun.proxy.$Proxy259.execute(Unknown Source)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.select(DefaultSqlSession.java:170)
	... 11 common frames omitted