RE: View contents of global temp table
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 floggingwith 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-
Re: View contents of global temp table
LOL! Chris, there is a Russian saying: "You are playing with a fire" :-) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, October 07, 2002 1:54 PM 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 floggingwith 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 me
RE: View contents of global temp table
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 floggingwith 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 info
RE: View contents of global temp table
Title: RE: View contents of global temp table Thank you Melissa. -Original Message-From: Godlewski, Melissa [mailto:[EMAIL PROTECTED]]Sent: Monday, October 07, 2002 11:54 AMTo: Multiple recipients of list ORACLE-LSubject: RE: View contents of global temp table The global table is visible (Global) to all sessions, but each session can only see it's own data within the table. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 11:34 AM To: Multiple recipients of list ORACLE-L Subject: RE: View contents of global temp table 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).
RE: View contents of global temp table
Title: RE: View contents of global temp table The table may not necessarily be truncated which depends on the setting whether it gets truncated on commit(or rollback) or at the end of the session. no other session can however see the data. Regards Naveen -Original Message-From: Bishop Lewis [mailto:[EMAIL PROTECTED]]Sent: Monday, October 07, 2002 8:31 PMTo: Multiple recipients of list ORACLE-LSubject: RE: View contents of global temp table *Your session* should be able to see the rows. If you commit (or rollback) the table will be truncated. Are you commiting? Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 15:34To: Multiple recipients of list ORACLE-LSubject: RE: View contents of global temp table This header confirms that this email message has been swept for thepresence of computer viruses. Corporate ITTHE WOOLWICH-- 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- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 9:43 AM To: Multiple recipients of list ORACLE-L Subject: View contents of global temp table 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).
Re: View contents of global temp table
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 an
RE: View contents of global temp table
Title: RE: View contents of global temp table The global table is visible (Global) to all sessions, but each session can only see it's own data within the table. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 11:34 AM To: Multiple recipients of list ORACLE-L Subject: RE: View contents of global temp table 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).
RE: View contents of global temp table
the 9i docs say that GLOBAL TEMPORARY is only for the session which creates it, and is either of session or transaction duration. Which means, you need to update the doc set you are looking at, it's wrong (and this is a surprise because) --- "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).
RE: View contents of global temp table
Actually, it depends on how the GTT was created. By default, the data is not available after a transaction COMMITs. One must use 'ON COMMIT PRESERVE ROWS' to be able to see the data, within the same session, after COMMITs. - Kirti - Original Message - To: Multiple recipients of list ORACLE-L Sent: Monday, October 07, 2002 10:33 AM 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: Deshpande, Kirti 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).
RE: View contents of global temp table
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).
Re: View contents of global temp table
You are correct. You can only see data for that session if you perserve rows Rick "Igor Neyman" <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Re: View contents of global temp table om 10/07/2002 11:00 AM Please respond to ORACLE-L I'd disagree. I've always thought, that you can only see your "own" data in temp table, and not "other session" data. You share only table definition (not contents) with other sessions. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Monday, October 07, 2002 10:33 AM Subject: RE: View contents of global temp table 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- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 9:43 AM To: Multiple recipients of list ORACLE-L Subject: View contents of global temp table 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: 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).
RE: View contents of global temp table
Title: RE: View contents of global temp table *Your session* should be able to see the rows. If you commit (or rollback) the table will be truncated. Are you commiting? Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 15:34 To: Multiple recipients of list ORACLE-L Subject: RE: View contents of global temp table This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- 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- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 9:43 AM To: Multiple recipients of list ORACLE-L Subject: View contents of global temp table 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).
RE: View contents of global temp table
?? 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).
Re: View contents of global temp table
Title: RE: View contents of global temp table I'd disagree. I've always thought, that you can only see your "own" data in temp table, and not "other session" data. You share only table definition (not contents) with other sessions. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Monday, October 07, 2002 10:33 AM Subject: RE: View contents of global temp table 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- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 9:43 AM To: Multiple recipients of list ORACLE-L Subject: View contents of global temp table 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).
RE: View contents of global temp table
Rick, Within that session, you can see the data. Another session cannot see the data, however. That is why it is a "temporary" table. Tom Mercadante Oracle Certified Professional -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: Mercadante, Thomas F 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).
RE: View contents of global temp table
Title: RE: View contents of global temp table 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- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 9:43 AM To: Multiple recipients of list ORACLE-L Subject: View contents of global temp table 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). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2