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

Home -> Community -> Usenet -> c.d.o.server -> Re: Can I create temporary table across sessions/instance

Re: Can I create temporary table across sessions/instance

From: gdb_dsr <ge_2000_2001_at_yahoo.com>
Date: 31 Oct 2003 09:56:35 -0800
Message-ID: <6299d152.0310310956.5612859f@posting.google.com>


To Turn off every disk activity possiable.

vslabs_at_onwe.co.za (Billy Verreynne) wrote in message news:<1a75df45.0310302115.5a3eff63_at_posting.google.com>...
> ge_2000_2001_at_yahoo.com (gdb_dsr) wrote
> >
> > 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.
>
> One session wanting to see the updates & data of another session.
> Across instances.
>
> That sounds like a job that the default/normal/standard tables in
> Oracle has been doing since forever.
>
> Why the need for a temporary table then? What problem are you trying
> to resolve with a temporary table with data that persist across
> sessions and instances?
Received on Fri Oct 31 2003 - 11:56:35 CST

Original text of this message

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