Re: Any possible way to view global temp table data for another active session?

From: Kellyn Pedersen <kjped1313_at_yahoo.com>
Date: Mon, 1 Feb 2010 20:05:58 -0800 (PST)
Message-ID: <716319.72554.qm_at_web32004.mail.mud.yahoo.com>

Unless someone else is aware of magic that I'm not, I agree with Sir Baldwin below.  I had a few GTT that we used in our old mart code and I hated data issues that I couldn't track in the darn things as they happened!

Kellyn Pedersen
Multi-Platform DBA
I-Behavior Inc.
http://www.linkedin.com/in/kellynpedersen www.dbakevlar.blogspot.com
 
"Go away before I replace you with a very small and efficient shell script..."

• On Mon, 2/1/10, Steve Baldwin <stbaldwin_at_multiservice.com> wrote:

From: Steve Baldwin <stbaldwin_at_multiservice.com> Subject: Re: Any possible way to view global temp table data for another active session? To: brent_day_at_comcast.net
Cc: oracle-l_at_freelists.org
Date: Monday, February 1, 2010, 4:31 PM

I'm almost certain the answer is <NO>.  If you want to do this you'll need to use a 'regular' table or some other IPC mechanism.

On Tue, Feb 2, 2010 at 9:00 AM,  <brent_day_at_comcast.net> wrote:
> I am looking for a way to grab a snapshot of data or view the current data
> from another session's global temporary table data?
> Is this even possible?
> Thanks
> Brent
>

--
http://www.freelists.org/webpage/oracle-l





      
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 01 2010 - 22:05:58 CST