MS Query error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been using an external SQL browser to write the SQL query of an Oracle database using EXCEL and the PIVOT table function. The process has worked well until the last SQL query. I sent to query in an Oracle browsr and cou and pasted the SQL into MS Query. The same as I have done 100 times. The query started and ran for 5 or 6 minutes. The following error appeard in a message box: "Unable to extend temp segmnet by 128 in tablespace TEMP". I assume that the data OLAP cube got too large for the RAM on my PC. I have 512M of RAM. What is needed to get the MS Query to work on this SQL?
 
How about posting the SQL?

--

Jim Mahoney said:
I have been using an external SQL browser to write the SQL query of
an Oracle database using EXCEL and the PIVOT table function. The
process has worked well until the last SQL query. I sent to query in
an Oracle browsr and cou and pasted the SQL into MS Query. The same
as I have done 100 times. The query started and ran for 5 or 6
minutes. The following error appeard in a message box: "Unable to
extend temp segmnet by 128 in tablespace TEMP". I assume that the
data OLAP cube got too large for the RAM on my PC. I have 512M of
RAM. What is needed to get the MS Query to work on this SQL?
 
Back
Top