Re: How to create temp table in memory in Oracle

ORACLE does not have a similar concept for temp tables, but you can create a table, mark it as CACHE, do a full table scan, and it will remain in the SGA until forced out.

Wayne Linton, I.S.P.
Shell Canada Ltd.

ChanderR_at_KochInd.com wrote:
>
> Hi;
>
> I am trying to find out the way to create temp table in memory in oracle
> as you do in Sybase or MS SQL server (eg. create table #temp_table). This
> table will stay in memory, will go away at the end of user transaction.
>
> Any help will be greatly appreciated.
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
  Received on Thu Jul 17 1997 - 00:00:00 CEST