From oracle-l-bounce@freelists.org Wed Oct 27 05:49:13 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i9RAnDD15086 for ; Wed, 27 Oct 2004 05:49:13 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i9RAnCI15081 for ; Wed, 27 Oct 2004 05:49:12 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 53CFB72D607; Wed, 27 Oct 2004 04:44:25 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06911-14; Wed, 27 Oct 2004 04:44:25 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7F5AC72D6BE; Wed, 27 Oct 2004 04:44:24 -0500 (EST) Message-ID: <20041027094240.12075.qmail@web20701.mail.yahoo.com> Date: Wed, 27 Oct 2004 02:42:40 -0700 (PDT) From: Charlotte Hammond Subject: Re: DEFAULT Tempfile To: ORACLE-L MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 11574 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: charlottejanehammond@yahoo.com Precedence: normal Reply-To: charlottejanehammond@yahoo.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi Syed, I'm not sure I understand the question. You don't have a DEFAULT tempfile, you have a DEFAULT temporary TABLESPACE. eg. ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP; This is just a normal temporary tablespace WHICH YOU MUST HAVE ALREADY CREATED (ie you cannot use a permanent tablespace), so the tempfiles associated with it will appear in controlfile trace or in dba_temp_files. To check your default temporary tablespace: SELECT * FROM database_properties WHERE property_name = 'DEFAULT_TEMP_TABLESPACE'; Hope this helps, - Charlotte Hi guys In control file trace I could not see DEFAULT tempfile and dba_temp_files also does not have any record. But if I added any new temp tablespace I could see this in both? Could someone put a point on this please Thanks Syed -- http://www.freelists.org/webpage/oracle-l --------------------------------- Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. -- http://www.freelists.org/webpage/oracle-l