Temporary tables. urgent!!!!

[gsdavid]

In ORACLE 8i, for temporary tables and cursors, after creation if we are incrementally trying to query the temporary table or cursor (in profile reports), there is no guarantee that we will get the same connection as the one we got for the first time because we are using pooled connections from the middle tier. This could lead to data integrity issues. To solve this problem, we have to go for permanent tables OR file system which are costly operations. We would like to know whether there is any alternative solution to overcome this problem. Probably, we can check whether anybody else has faced a similar problem in the past and what was done to solve the same. Can materialised views in ORACLE 8i be used for this purpose ?

Please help. Very urgent!!!!

 

[kindus]

Hi David,
In Oracle8i we can create GLOBAL temporary table which can be either TRANSACTION specific or SESSION specific, data remain consistent within the transaction or session. So if you are thinking for disconnecting the seesion than global temporary table will not be helpfull. So far as materialized view is concerned it will do your job and it gives additional advantage such as automatic refresh which can be online or scheduled etc. but at the expense of configuration and maintenance of materialized views.

kindus

 

[gsdavid]

Thanks Kundus

David