Re: Temporary tables in Oracle 8 ?

I wish. Sorry you can't. I've asked a number of people from Oracle and they all say the same thing - no such thing exists. What we decided to do is create persistent tables and manipulate the data in those tables and rollback the table when we're done. Thus, we never commit data to the table. The drawback, of course, is all insert/update/delete operations are recorded in the rollback segment. We use only in the places we absolutely have to.

NOTE: If you decide to use this approach and you add a unique index to one of the columns, two users cannot insert into the table at the same time even though they never commit their data. We got around this problem by adding a session id column and making the index on the session id plus the column we wanted to use for our unique key.

Chris

Frédéric LEFEBVRE wrote in message <3545d8a6.10015431_at_news.iway.fr>...
>Can I have temporary tables in Oracle 8, like in Sybase or Ingres ?
>(memory tables, not PL/SQL table, whitch can be access with select
>statements)
>
>Thanks
>
>Fred
>
Received on Wed Apr 29 1998 - 00:00:00 CDT