Yes, the join is possible with the oracle spatial also, but wery slow. From shp file the image generation time is avg 400ms, but same layer from oracle spatial is avg 4300ms. With OGR it is possible the following format: CONNECTION "xxx.shp" DATA "SELECT * FROM xxx LEFT JOIN ORACLE:....?