Re: Where is a temp tables DDL stored?

g3000 wrote:
> Im on Win2k3 server Standard Ed.
> Oracle9i ( 9.2.0.6 )
>
> Creating several temp tables that are transaction specific.
>
> Im noticing that after executing the ddl for these tables and viewing
> them via Enterprise Manager the tablespace is listed as CWMLITE and not
> the default tablespace of the user who was creating it.
>
> Can I define a tablespace for a temp table as I do for a regular table?
> The 9i docs dont give an example that way.
>
> I have the TEMP tablespace defined as the users temporary tablespace.

All DDL is stored in the Data Dictionary in the SYSTEM tablespace.

The data, if you are referring, improperly, to Global Temporary Tables is stored in the TEMP tablespace.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)