Re: Q:fast temporrary table

in Oracle 8i:

Create temporary table tablename .... on commit preserve rows .....;

will create a temporary table, store rows temporary and truncate the table when at the end of the user session.

HTH John Chiu

Stojan Stojanov <stojanov_at_pcs.bg> wrote in message news:384cd5bb.0_at_news.obs.bg...
> Hello all.
> Is it possible to create a temporary table (not persistent) in ORACLE?
> Temporrary means that it is destroied automaticaly after closing oracle
> session. I need a table which is fully cached by ORACLE and operations
over
> this table are very fast (insert, update, delete, join with other tables).
> It is not necessary other sessions to use this table. The table will not
be
> very large. One column only and no more 20 000-30 000 records.
>
> Thanks in advance
>
>
>
Received on Tue Dec 07 1999 - 05:11:51 CST