Re: Temprorary Tables

Would you mind sharing some thoughts about how to create a temp table in a procedure, populate it, loop thru it, and then drop it? Thank you,
Lesliet
In article <56camn$3kb_at_reader1.reader.news.ozemail.net>, Steve McDougall <prsmcb_at_ozemail.com.au> wrote:
>Shapiro Dmitriy <shapiro_at_esd.kodak.com> wrote:
>
>>Hi,
 

>> I did not find the way to create a Temprorary Table on Oracle.
>> If someone knows, please help.
 

>>Thank you.
>
>Shapiro,
>
>ORACLE does not actually use temporary tables. It does use
>temporary segments (for sorts and similar stuff). If you want to
>use a table temporarily, you will have to create it, have your
>wicked way with it, then drop it. If you need to use temporary
>segments, about the only control you have is to point your
>temporary segments to a particular tablespace ie.
> ALTER USER <uname> TEMPORARY TABLESPACE <tsname>
>
>You can then control space allocation by altering the default
>storage parameters for the tablespace.
>
>Hope this helps
>
>Steve
>
>Steve McDougall
>AIX SysAdmin / ORACLE DBA
>Dept Immigration & Multicultural Affairs
>Australia
>email: prsmcb_at_ozemail.com.au
>
Received on Wed Nov 13 1996 - 00:00:00 CET