test.txt

 <plugin>
		        <groupId>org.apache.maven.plugins</groupId>
		        <artifactId>maven-surefire-plugin</artifactId>
		        <version>2.18.1</version>
		        <configuration>
		          <skipTests>true</skipTests>
		        </configuration>
		      </plugin>
		      
		      currentpolicyaddress
		      
		      ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
		      
		      
		      
	select 
    rpsi.POLICY_NO policyNo,rpsi.SERVICER_NO servicerNo,po.BRANCH_CODE branchCode,si.EMP_NAME empName,
    po.CHANNEL_TYPE AS channelType,bi.BRANCH_NAME branchName,ppi.PREM_DUE_DATE premDate,ctl.DESCRIPTION AS description
     from rn_policy_service_info rpsi,policy po,branch_code_relation bcr,policy_prem_info ppi
		where rpsi.policy_no=po.policy_no
		and rpsi.policy_no=ppi.policy_no
		and bcr.branch_code=po.branch_code
		and bcr.relative_grade>-1
		and staff_info si on si.emp_no = rpsi.servicer_no
		and branch_info bi on bi.branch_code = po.branch_code
		and CHANNEL_TYPE_TBL CTL ON  CTL.CHANNEL_TYPE = PO.CHANNEL_TYPE
		and bcr.relative_branch_code = #{branchCode,jdbcType=VARCHAR}
		AND ppi.PREM_DUE_DATE >= "TO_DATE"(#{nowMonth},'yyyy-MM-dd hh24:mi:ss')
		AND ppi.PREM_DUE_DATE &lt; "TO_DATE"(#{nextMonth},'yyyy-MM-dd hh24:mi:ss')