ora-01652 error

[runnerlk]

I have created a VB.net app that executes a query against an Oracle 10.2.0.3 database to retrieve valuse and enter them in to an SQL2005 standard ed db. i am getting an MS ODBC driver for Oracle error message ora-01652:unable to extend temp segment by 128 in tablespace TEMP". Here is the code that's throwing the exception:

SelectString = "Select distinct c.carrid, c.cvg_id, c.polnbr, c.cov_effdt,ie.insured_name, cv.cmb_id From coverage c, insured_entity ie, cmb_cov cv Where c.placeholder_id = " & placeholder_id.ToString & " And ie.carrid = c.carrid And ie.polnbr = c.polnbr And ie.cov_Effdt = c.cov_Effdt And ie.entity_cd = '001'And NVL(TRIM(ie.cont_seq_nbr),'001') = '001'AND (ie.name_expdt is null or ie.name_expdt >= c.cov_expdt) AND c.cvg_id = cv.cvg_id AND cv.INCLUDE_DT = (select max(include_dt)from cmb_cov where cvg_id = c.cvg_id) AND cv.exclude_dt is null;"
'Connect and Run Query
DA = New OleDbDataAdapter(SelectString, ConnectString)

'Fill Temp Table "IndexData with Query Results
DA.Fill(DS, "IndexData")
I can't image that it's a table size since the table should be populated with no more than one row. The MS driver for Ora is v.2.575.1117.00. I have deployed this application successfully in the past with sql dbs as the lookup source.

any assistance would be greatly appreciated.

 

[ca8msm]

You need to talk to your oracle dba as your temp file size needs to be increased.


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]