Joe, Any developer can help you out there, the more junior the better. MERGE JOIN CARTESIAN As far as how many degrees of freedom one would need would be based upon the table and tempfile sizes ... I'm sure that you've gathered a few gems in your environment capable of blowing out a 32 GB temp space in a single select. hth. Paul On Fri, Oct 10, 2008 at 12:41 PM, Joe Smith <joe_dba@xxxxxxxxxxx> wrote: > How do you create temporary files as non-sparse files in oracle? > > I thought there was a note on metalink about this, but I can't find it > now. > > > thanks. > > > > > ------------------------------ > Get more out of the Web. Learn 10 hidden secrets of Windows Live. Learn > Now<http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns%21550F681DAD532637%215295.entry?ocid=TXT_TAGLM_WL_getmore_092008> > -- http://www.completestreets.org/faq.html http://safety.fhwa.dot.gov/ped_bike/docs/pamanual.pdf
