Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Glo temp table - when to use 'On commit preserve rows'?

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

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 11 Jun 2006 12:13:22 -0700
Message-ID: <1150053203.666714@bubbleator.drizzle.com>


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
Received on Sun Jun 11 2006 - 14:13:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US