Re: Can I create temporary table across sessions/instance

From: mcstock <mcstockx_at_xenquery.com>
Date: Thu, 30 Oct 2003 19:30:46 -0500
Message-ID: <o5mdncx9K5DAMDyiRVn-iA@comcast.com>

oracle temporary tables are designed to hold session-specific data

if you need to see data from other sessions, the data must be committed in standard oracle tables

if the data that needs to be seen across sessions must be cleaned up at the end of the session, create a BEFORE LOGOFF trigger to do the clean-up

-- 
----------------------------------------
Mark C. Stock
www.enquery.com
(888) 512-2048


"gdb_dsr" <ge_2000_2001_at_yahoo.com> wrote in message
news:6299d152.0310301547.1ac25287_at_posting.google.com...


> Hi,

>

> Is it possiable to see the data of other sessions

> and their updates. I need a temporary table to be

> accessesed (I see the name but no data from other

> session connected to second instance) from two

> different sessions in 9i RAC environment. I can

> not find it in oracle docs. Wondering if you

> have gonethrough this.

>

> Thanks, Raju

Received on Thu Oct 30 2003 - 18:30:46 CST