List:MaxDB« Previous MessageNext Message »
From:JON Date:February 19 2003 7:20pm
Subject:Space for results table exhausted
View as plain text  
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




Thread
Space for results table exhaustedJON19 Feb
  • Re: Space for results table exhausted(Peter Willadt)20 Feb
  • Re: Space for results table exhaustedJON20 Feb
RE: Space for results table exhaustedElke Zabach20 Feb
  • [SAPDB][DATATYPE][MSSQL] money in sapdb?Massimo Renzi20 Feb
    • Re: [SAPDB][DATATYPE][MSSQL] money in sapdb?Flemming Frandsen20 Feb
RE: Space for results table exhaustedNoah J SILVA20 Feb
RE: [SAPDB][DATATYPE][MSSQL] money in sapdb?Elke Zabach20 Feb
  • RE: [SAPDB][DATATYPE][MSSQL] money in sapdb?John Holland20 Feb
RE: Space for results table exhaustedHolger Becker21 Feb