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" <cgrabowy_at_fcg.com> 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
> ineyman_at_perceptron.com
>
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> 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" <cgrabowy_at_fcg.com> 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: Rick_Cale_at_teamhealth.com
> > > 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: ListGuru_at_fatcity.com (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: cgrabowy_at_fcg.com
> > >
> > > 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: ListGuru_at_fatcity.com (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: wisernet100_at_yahoo.com
> >
> > 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: ListGuru_at_fatcity.com (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: ineyman_at_perceptron.com
>
> 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: ListGuru_at_fatcity.com (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: cgrabowy_at_fcg.com
>
> 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: ListGuru_at_fatcity.com (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: wisernet100_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Mon Oct 07 2002 - 13:49:03 CDT
