Re: Where is a temp tables DDL stored?

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Wed, 14 Sep 2005 14:44:33 GMT
Message-ID: <Xns96D14EC2B855CSunnySD@68.6.19.6>

"g3000" <carlton_gregory_at_yahoo.com> wrote in news:1126707526.762209.164070_at_f14g2000cwb.googlegroups.com:

> My question is how does Oracle determine where the DDL for the temp
> table is stored?
>

The DDL is stored in the Data dictionary. The above question is very different from your original; below.

> Can I define a tablespace for a temp table as I do for a regular table?

Yes, tablespace can be specified regardless of table type.

All of the above still begs the question as to WHY you think a "temp" table is actually needed. Received on Wed Sep 14 2005 - 09:44:33 CDT