RE: Is there anything called session specific tables

From: Jack C. Applewhite <japplewhite_at_inetprofit.com>
Date: Fri, 16 Mar 2001 12:34:43 -0800
Message-ID: <F001.002CF004.20010316072642@fatcity.com>

Tapas,

If you're on 8i (I don't think they're available on 8.0, but not sure), look at Global Temporary Tables. They are permanently defined in the data dictionary so triggers and packages and views, etc. can reference them, but the rows inserted, updated, and deleted in them are visible only to the session(s) acting on them. Those rows are automatically deleted at the end of the session or the end of each transaction, depending on how you create the tables. Very nice feature.

Jack

Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
japplewhite_at_inetprofit.com

-----Original Message-----
tapas dutta
Sent: Friday, March 16, 2001 1:36 AM
To: Multiple recipients of list ORACLE-L

Hello Listers,

I am facing a typical problem. In one of my D2K appliaction I need to first populate the data in a particular itermediate
table and then run the reporting job. The data population has been done in the report trigger. But the problem is if at the same time another user fires the same report, the data population becomes erroneous as he is also sharing the same table.

Is there any concept of session specific tables.

Please help.
Regards,

Tapas

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: tapas dutta
  INET: tapasoracle_at_umtl.co.in

Fat City Network Services    -- (858) 538-5051  FAX: (858)
538-5051
San Diego, California        -- Public Internet access /
Mailing Lists
------------------------------------------------------------
--------
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: Jack C. Applewhite
  INET: japplewhite_at_inetprofit.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Fri Mar 16 2001 - 14:34:43 CST