Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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.orgReceived on Sun Jun 11 2006 - 14:13:22 CDT