Re: Can I create temporary table across sessions/instance

Mark,
Thanks for your response.

I am actually looking for some entity that resides in memory (no, well! minimal disk activity is ok as I am not interested in *any* log data) and can be seen across RAC instances just like table and changes made to it should reflect both sides. My sessions generate data/change/access finally discard the data and free the resources. I am considering to use regular table with "_disable_logging" at least to turn off redo, undo log, I know the down side of it but I dont know any better option.

Thanks
Raju

"mcstock" <mcstockx_at_xenquery.com> wrote in message news:<o5mdncx9K5DAMDyiRVn-iA_at_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 Fri Oct 31 2003 - 01:39:38 CST