There is a cache_temp_table() hint, but I haven't done any experiments on it.
http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/appearances.html Public Appearances - schedule updated 10th Jan 2006
Do you guys remember what was the hidden/special hint to create a global temporary table in memory or to force the data to stay in memory?
-- Christo Kutrovsky Senior Database/System Administrator The Pythian Group -- http://www.freelists.org/webpage/oracle-l