> 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?