Re: [sqr-users] TEMPORARY TABLES

["George Jansen" <GJANSEN@aflcio.org>]

GLOBAL TEMPORARY  tables should work fine; however you should know that

a. "GLOBAL" is something of a misnomer; they exist, like other objects,
within schemas. You can, however, create public synonyms for them.

b. The default for Oracle's GTTs is "ON COMMIT DELETE ROWS", which
means that if along the way you happen to commit a transaction you've
emptied the table. You must specify "ON COMMIT PRESERVE ROWS" if the
data is to persist through transactions.

c. One session cannot see another's information in such a table.
Doesn't matter whether the username is the same or not, it just can't
see it, which is what you want.

d. The data goes away when the session ends, which is also what you
want.

e. You can't use them in distributed transactions.






_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users