SILVA Noah wrote > > I am getting an error: > > General error, -904 POS(!) Space for result tables exhausted, > No Result. > > this is on a query something like > > select a, b, c, d, e > from t1, t2, t3, t4 > where t1.a = t2.a, t1.a=t3.a(+). t1.a=t4.a(+) > > Note that it runs ok up until I add the second (+). > I don't believe that i am creating an infinite set or > anything like that. > > The db itself is 60mb, made from a 20mb devspace and a 40mb > devspace, and > is only 12% used. Is there a separate place to specify the > result space? > (I saw no such setting in the dbmgui). >
There is no special space for result tables in SAP DB. The only way to increase the space is to add another data volume. The reason for the different behaviour with the additional outer join is that the join generates larger temporary results without the limitation of the inner join condition. Kind regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
