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

dean wrote:
> 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

What version of Oracle?
Post the DDL that created the table.

What you describe is clearly impossible unless you are making a syntax error or your front-end tool is using transient connections.

Also post the connection string from your TNSNAMES.ORA.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org