Glo temp table - when to use 'On commit preserve rows'?

Hello all,

I was caught once again for leaving off the 'on commit preserve rows' part of the create global temporary table statement. After an hour of headscratching I realized that I had left this part off,, and as usual as soon as I inserted rows into a table, the disappeared into thin air (that is, even in the same session).

Could someone explain this to me? It appears I do not need to 'commit' to re-use the (data in my session), even if I have on commit preserve rows. And if I don't have that, my data isn't even available during my session, even after I insert some rows into the table.

Thanks for any help,

Dean Received on Thu Jun 08 2006 - 23:06:39 CDT