Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newshub.sdsu.edu!headwall.stanford.edu!newsfeed.stanford.edu!sn-xit-02!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.oracle.server Subject: Re: Where is a temp tables DDL stored? Date: Wed, 14 Sep 2005 08:38:21 -0700 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1126712247.735544@yasure> User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <1126705798.012355.18740@g49g2000cwa.googlegroups.com> In-Reply-To: <1126705798.012355.18740@g49g2000cwa.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@oracle.advtechserv.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 24 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251501 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@x.washington.edu (replace x with u to respond)