Re: Temprorary Tables

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