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.service_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,staff_info si,CHANNEL_TYPE_TBL CTL,branch_info bi
    where 
    si.emp_no = rpsi.service_no
		and bi.branch_code = po.branch_code
		and CTL.CHANNEL_TYPE = PO.CHANNEL_TYPE
    and 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 bcr.relative_branch_code = '864200'
		AND ppi.PREM_DUE_DATE >= "TO_DATE"('2018-01-01 00:00:00','yyyy-MM-dd hh24:mi:ss')
		AND ppi.PREM_DUE_DATE <= "TO_DATE"('2018-01-30 00:00:00','yyyy-MM-dd hh24:mi:ss')
    and po.CHANNEL_TYPE in('01','02','03','04','05','07','09')