FAQ
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).

Search Discussions

  • Jamadagni, Rajendra at Oct 7, 2002 at 2:33 pm
    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: Jamadagni, Rajendra
    INET: Rajendra.Jamadagni_at_espn.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).

    text/plain attachment: ESPN_Disclaimer.txt
  • Mercadante, Thomas F at Oct 7, 2002 at 2:53 pm
    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: 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: Mercadante, Thomas F
    INET: NDATFM_at_labor.state.ny.us

    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).
  • Bishop Lewis at Oct 7, 2002 at 3:00 pm
    *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 - lewis.bishop_at_woolwich.co.uk

    -----Original Message-----
    Sent: 07 October 2002 15:34
    To: Multiple recipients of list ORACLE-L

    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-----
    ]
    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
    <http://www.orafaq.com>
    --
    Author:
    INET: Rick_Cale_at_teamhealth.com
    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    <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: Bishop Lewis
    INET: Lewis.Bishop_at_woolwich.co.uk

    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).
  • Igor Neyman at Oct 7, 2002 at 3:00 pm
    RE: View contents of global temp tableI'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
    ineyman_at_perceptron.com


    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: Rick_Cale_at_teamhealth.com
    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: 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: 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).
  • Grabowy, Chris at Oct 7, 2002 at 3:13 pm
    ??

    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).
  • Rick_Cale_at_teamhealth.com at Oct 7, 2002 at 3:24 pm
    You are correct. You can only see data for that session if you perserve
    rows

    Rick

    "Igor Neyman"

    Sent by: cc:
    root_at_fatcity.c 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
    ineyman_at_perceptron.com

    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: Rick_Cale_at_teamhealth.com
    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: 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:
    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).
  • Deshpande, Kirti at Oct 7, 2002 at 3:34 pm
    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: 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: Deshpande, Kirti
    INET: kirti.deshpande_at_verizon.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).
  • Rachel Carmichael at Oct 7, 2002 at 3:34 pm
    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" 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).
  • Rachel Carmichael at Oct 7, 2002 at 3:39 pm
    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" 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).
  • Godlewski, Melissa at Oct 7, 2002 at 3:53 pm
    The global table is visible (Global) to all sessions, but each session can
    only see it's own data within the table.

    -----Original Message-----
    Sent: Monday, October 07, 2002 11:34 AM
    To: Multiple recipients of list ORACLE-L

    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" 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: Godlewski, Melissa
    INET: Melissa.Godlewski_at_hq.doe.gov

    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).
  • Igor Neyman at Oct 7, 2002 at 3:59 pm
    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"
    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" 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).
  • Naveen Nahata at Oct 7, 2002 at 3:59 pm
    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-----
    Sent: Monday, October 07, 2002 8:31 PM
    To: Multiple recipients of list ORACLE-L

    *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 - lewis.bishop_at_woolwich.co.uk

    -----Original Message-----
    Sent: 07 October 2002 15:34
    To: Multiple recipients of list ORACLE-L

    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-----
    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: Naveen Nahata
    INET: naveen_nahata_at_mindtree.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).
  • Grabowy, Chris at Oct 7, 2002 at 5:49 pm
    Thank you Melissa.

    -----Original Message-----
    Sent: Monday, October 07, 2002 11:54 AM
    To: Multiple recipients of list ORACLE-L

    The global table is visible (Global) to all sessions, but each session can only see it's own data within the table.

    -----Original Message-----
    Sent: Monday, October 07, 2002 11:34 AM
    To: Multiple recipients of list ORACLE-L

    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" 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: 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).
  • Grabowy, Chris at Oct 7, 2002 at 5: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 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"
    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" 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).
  • Igor Neyman at Oct 7, 2002 at 6:13 pm
    LOL!

    Chris, there is a Russian saying: "You are playing with a fire" :-)

    Igor Neyman, OCP DBA
    ineyman_at_perceptron.com

    Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    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 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"
    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" 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).

    --
    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).
  • Rachel Carmichael at Oct 7, 2002 at 6:49 pm
    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" 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"
    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" 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).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 7, '02 at 1:43p
activeOct 7, '02 at 6:49p
posts17
users10
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase