From: Date: February 19 2003 7:20pm Subject: Space for results table exhausted List-Archive: http://lists.mysql.com/maxdb/12548 Message-Id: I searched through the mailing list and found some good clues, but a little shy on answers. I have the following query created with the visual query tool: SELECT "OCPC"."TBLARCHOWNER"."NAME","OCPC"."TBLPROJAO"."SHOWONRESULTS","OCPC"."TBLA RCHOWNER"."PHONE","OCPC"."TBLARCHOWNER"."ZIP","OCPC"."TBLARCHOWNER"."STATE", "OCPC"."TBLARCHOWNER"."CITY","OCPC"."TBLARCHOWNER"."ADDR1" FROM "OCPC"."TBLAOTYPE","OCPC"."TBLARCHOWNER","OCPC"."TBLPROJAO" WHERE "OCPC"."TBLARCHOWNER"."ID"= "OCPC"."TBLPROJAO"."ARCHOWNERID" (+) AND "OCPC"."TBLAOTYPE"."AOTYPEID"= "OCPC"."TBLPROJAO"."AOTYPEID" (+) AND ((tblProjAO.ShowOnResults)=TRUE) and tblProjAO.ProjID = 8329 order by ProjAO When I execute the query I get the Space for results table exhausted error. I'm using kernal 7.3.0, SQL Studio 7.4.3.6, ODBC driver 7.04.03.00. serverdbstatistics: SERVERDBSIZE MAXDATAPAGENO MAXPERM USEDPERM PCTUSEDPERM USEDTMP PCTUSEDTMP UNUSED PCTUNUSED UPDATEDPERM SERVERDBFULL LOGSIZE USEDLOG PCTUSEDLOG LOGNOTSAVED PCTLOGNOTSAVED LOGSINCEBACKUP RESERVEDREDO LOGSEGMENTSIZE SAVEPOINTS CHECKPOINTS 17500 8537 13127 8521 65 18 0 4588 35 7170 NO 8747 1275 15 1220 14 9936 4373 0 16 9 tablestatistics: OWNER TABLENAME DESCRIPTION CHAR_VALUE NUMERIC_VALUE OCPC TBLAOTYPE Used pages ? 1 OCPC TBLARCHOWNER Used pages ? 72 OCPC TBLPROJAO Used pages ? 124 explain: OWNER TABLENAME COLUMN_OR_INDEX STRATEGY PAGECOUNT O D T M OCPC TBLAOTYPE TABLE SCAN 64 OCPC TBLARCHOWNER TABLE SCAN 396 OCPC TBLPROJAO TABLE SCAN 61 OCPC RESULT IS COPIED , COSTVALUE IS > 2 E10 I'm assuming I'm missing something very simple and obvious to a more experienced user. Any help will be greatly appreciated. Jon