MS Query error

J

Jim Mahoney

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?
 
O

onedaywhen

How about posting the SQL?

--

Jim Mahoney said:
I have been using an external SQL browser to write the SQL query of
Click to expand...
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
office 2007 Excel OLAP query Lost Data 0
Pass-Through Query Error 1
Problem with Database Query from Excel 2003 1
pivot table report 0
Alternatives to MS Query for Pivot Tables & Cubes 0
Excel 2003 to 2007 help 0
Pivot table Timeout 2

Top