Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Temporary tables visible to all sessions

Temporary tables visible to all sessions

From: Konstantin Kudin <konstantin_kudin_at_yahoo.com>
Date: 9 Jul 2003 13:18:57 -0700
Message-ID: <ff88eb34.0307091218.373b70a3@posting.google.com>


Hi,

 I am curious if it is possible to create a temporary table (in Oracle 8.1.7) that would be visible to all sessions. Then its data would go away when the database is shutdown. Hopefully, due to its temporary nature such a table would also be writable in read-only mode.

 A possible usage would be to keep track of web users when each user is issued an ID on web logon. The ID is passed back and forth as a cookie or a hidden form field to authenticate the user. Stored procedures would validate legitimacy of requests by the ID. The IDs would be stored in an all session visible temporary table. Hypothetically if the database is opened in read-only mode, the users can still login from the web, get IDs, and do at least some things since the table with IDs is hopefully writable. Is this possible or is there a better way?

 I know that Oracle has "global temporary" tables, which are either session-specific or transaction-specific. Are these writable in read-only mode? There is a way to make sure that Oracle can sort in read-only mode and thus perform writes to a temporary tablespace. Would the same mechanism work with "global temporary" tables thus making them writable, or not?

 Thanks!

 Konstantin Received on Wed Jul 09 2003 - 15:18:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US