Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Using connection pool on Oracle 8i temporary tables

 
David Manoj
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,
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 ?
Can anybody help??
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic