December 12th. You missed your opportunity to heckle me at the last one, as I was a presenter there.
the december meeting is the last one I will be working on. I am giving up the meeting agenda work at the end of the year. heckle away..... if you dare --- "Grabowy, Chris" <[EMAIL PROTECTED]> wrote: > Thank you Igor. > > When is the next NYOUG? I can't wait to give her some grief for say > an hour or two...and a public flogging....with a wet noodle. > > -----Original Message----- > Sent: Monday, October 07, 2002 11:59 AM > To: Multiple recipients of list ORACLE-L > > > Rachel, > > I agree with Chris, and I don't see any contradiction, in what he > said. > What docs say, is that only definition (not contents) of GLOBAL > TEMPORARY is > visible to all sessions. > And, in this case docs are correct, at least according to my > experience with > GLOBAL TEMPORARY tables. > And their behavior didn't change in 9i. > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] > > > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, October 07, 2002 11:34 AM > > > > 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). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Igor Neyman > 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). === message truncated === __________________________________________________ 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).