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
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
