Chris, you just contradicted yourself.... GLOBAL TEMPORARY (from the docs you quoted) is visible to all sessions, TEMPORARY is visible only to the session creating it
Rachel --- "Grabowy, Chris" <[EMAIL PROTECTED]> wrote: > ?? > > The data in a global temp table is only visible to the session that > inserted the data, the other sessions cannot see the data, regardless > of a commit. > > A quick search of the doc... > > GLOBAL TEMPORARY > > Specify GLOBAL TEMPORARY to indicate that the table is temporary and > that its definition is visible to all sessions. The data in a > temporary table is visible only to the session that inserts the data > into the table. > > A temporary table has a definition that persists the same as the > definitions of regular tables, but it contains either > session-specific or transaction-specific data. You specify whether > the data is session- or transaction-specific with the ON COMMIT > keywords (below). > > Here is the (broken up) link.... > > http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/statem3e.htm#2061078 > > -----Original Message----- > Sent: Monday, October 07, 2002 10:34 AM > To: Multiple recipients of list ORACLE-L > > > Rick, > it is like any other table ... if the data is committed and you have > access you can see data, else no you can't. > Raj > ______________________________________________________ > Rajendra Jamadagni MIS, ESPN Inc. > Rajendra dot Jamadagni at ESPN dot com > Any opinion expressed here is personal and doesn't reflect that of > ESPN Inc. > QOTD: Any clod can have facts, but having an opinion is an art! > > > -----Original Message----- > Sent: Monday, October 07, 2002 9:43 AM > To: Multiple recipients of list ORACLE-L > > > Hi All, > In session 1 I am loading data into a global temp table. Is there > any way > to see contents of that table? > Thanks > Rick > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Grabowy, Chris > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __________________________________________________ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
