From oracle-l-bounce@freelists.org Thu Oct 13 03:26:12 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9D8QCK9017210 for ; Thu, 13 Oct 2005 03:26:12 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j9D8Q4vX017176 for ; Thu, 13 Oct 2005 03:26:05 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E30AC1FC468; Thu, 13 Oct 2005 03:25:57 -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 32713-05; Thu, 13 Oct 2005 03:25:57 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 509521FA9C9; Thu, 13 Oct 2005 03:25:57 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=JUsni4WwpYkuNKt9P1yIZFt5HWsqcSFWy6D4qfBi2/f1557Hfsd9gXOSyh7QiY/oeSx7kdPZ3gkK5sRt+g9BofRr3lNKavABgAv0ZPvEtItAWbd47br/3d4ry1uvW8fxxfIMieKCBajBcoGeXLRsQHvvp+Ppl+j3tA43GQ5FFrE= ; Message-ID: <20051013082400.20243.qmail@web31413.mail.mud.yahoo.com> Date: Thu, 13 Oct 2005 01:24:00 -0700 (PDT) From: raja rao Subject: dba_temp_file vs v$tempfile To: oracle list MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-752001388-1129191840=:19864" X-archive-position: 26891 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: raja4list@yahoo.com Precedence: normal Reply-To: raja4list@yahoo.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-3.7 required=5.0 tests=AWL,BAYES_00, FORGED_YAHOO_RCVD,HTML_MESSAGE autolearn=no version=2.63 --0-752001388-1129191840=:19864 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi All, A datafile (temp file of precise tool) has been deleted from os lelel without dropping from database. When I query the dba_temp_files it is showing: ERROR at line 1: ORA-01157: cannot identify/lock data file 607 - see DBWR trace file ORA-01110: data file 607: '/bio/u01/precise_i3_orcl_or_tmp_01.dbf' where as when I query v$tempfile, it is showing the file names properly without any error. Can someone explain me what is this strage behaviour. Thanks , Raj --------------------------------- Yahoo! Music Unlimited - Access over 1 million songs. Try it free. --0-752001388-1129191840=:19864 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit

Hi All,
 
A datafile (temp file of precise tool) has been deleted from os lelel without dropping from database.
 
When I query the dba_temp_files it is showing:
ERROR at line 1:
ORA-01157: cannot identify/lock data file 607 - see DBWR trace file
ORA-01110: data file 607: '/bio/u01/precise_i3_orcl_or_tmp_01.dbf'

where as when I query v$tempfile, it is showing the file names properly without any error.
Can someone explain me what is this strage behaviour.
 
Thanks ,
Raj

Yahoo! Music Unlimited - Access over 1 million songs. Try it free. --0-752001388-1129191840=:19864-- -- http://www.freelists.org/webpage/oracle-l