Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How Do I Create a Temporay Table?
Oracle doesnt seem to be having equivalent of temp tables/ tempdb as in SQL
Server.
A "temporary" tablespace is used by oracle automatically for sorting
operations ( provided it is assigned as temporary tablespace for the user
). Even the segments allocated here are NOT dropped after the query; it is
available for other users. (SQL Server drops all local temporary tables
after the session ).
//ram
Received on Fri Mar 07 1997 - 00:00:00 CST