Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: View contents of global temp table

RE: View contents of global temp table

From: Godlewski, Melissa <Melissa.Godlewski_at_hq.doe.gov>
Date: Mon, 07 Oct 2002 07:53:43 -0800
Message-ID: <F001.004E2417.20021007075343@fatcity.com>


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" <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: 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).
Received on Mon Oct 07 2002 - 10:53:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US