-- --Original Message-- -- From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]On Behalf Of raja rao Sent: 13 October 2005 09:24 To: oracle list Subject: dba_temp_file vs v$tempfile
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 (See ORA-01157.ora-code.com): cannot identify/lock data file 607 - see DBWR trace file ORA-01110 (See ORA-01110.ora-code.com): 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! <http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=36035/*http://music .yahoo.com/unlimited/> Music Unlimited - Access over 1 million songs. Try it free.
PLEASE READ: The information contained in this email is confidential and intended for the named recipient(s) only. If you are not an intended recipient of this email please notify the sender immediately and delete your copy from your system. You must not copy, distribute or take any further action in reliance on it. Email is not a secure method of communication and Nomura International plc ('NIplc') will not, to the extent permitted by law, accept responsibility or liability for (a) the accuracy or completeness of, or (b) the presence of any virus, worm or similar malicious or disabling code in, this message or any attachment(s) to it. If verification of this email is sought then please request a hard copy. Unless otherwise stated this email: (1) is not, and should not be treated or relied upon as, investment research; (2) contains views or opinions that are solely those of the author and do not necessarily represent those of NIplc; (3) is intended for informational purposes only and is not a recommendation, solicitation or offer to buy or sell securities or related financial instruments. NIplc does not provide investment services to private customers. Authorised and regulated by the Financial Services Authority. Registered in England no. 1550505 VAT No. 447 2492 35. Registered Office: 1 St Martin's-le-Grand, London, EC1A 4NP. A member of the Nomura group of companies.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1506" name=GENERATOR></HEAD> <BODY> <DIV><FONT face=Arial color=#0000ff size=2><SPAN class=089202708-13102005>Whats status does it shows you for it?</SPAN></FONT></DIV> <DIV> </DIV> <DIV> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-SIZE: 7.5pt; COLOR: navy"><FONT size=2></FONT></SPAN> </P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-SIZE: 7.5pt; COLOR: navy"><FONT size=2></FONT></SPAN> </P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-SIZE: 7.5pt; COLOR: navy"></SPAN> </P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-SIZE: 7.5pt; COLOR: navy"><FONT size=2>Regards</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-SIZE: 7.5pt; COLOR: navy"><FONT size=2>Amit</FONT></SPAN></P><SPAN style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: 'Times New Roman'; mso -fareast-font-family: 'MS Mincho'; mso-ansi-language: EN-GB; mso-fareast -language: EN-US; mso-bidi-language: AR-SA"><FONT size=2></FONT></SPAN></DIV> <BLOCKQUOTE> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-- --Original Message-- --<BR><B>From:</B> oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]<B>On Behalf Of </B>raja rao<BR><B>Sent:</B> 13 October 2005 09:24<BR><B>To:</B> oracle list<BR><B>Subject:</B> dba_temp_file vs v$tempfile<BR><BR></FONT></DIV> <DIV><BR>Hi All,</DIV> <DIV> </DIV> <DIV>A datafile (temp file of precise tool) has been deleted from os lelel without dropping from database.</DIV> <DIV> </DIV> <DIV>When I query the dba_temp_files it is showing:</DIV> <DIV>ERROR at line 1:<BR>ORA-01157 (See ORA-01157.ora-code.com): cannot identify/lock data file 607 - see DBWR trace file<BR>ORA-01110 (See ORA-01110.ora-code.com): data file 607: '/bio/u01/precise_i3_orcl_or_tmp_01.dbf'</DIV> <DIV><BR>where as when I query v$tempfile, it is showing the file names properly without any error.</DIV> <DIV>Can someone explain me what is this strage behaviour.</DIV> <DIV> </DIV> <DIV>Thanks ,<BR>Raj</DIV> <P> <HR SIZE=1> <A href="http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=36035/*http://music .yahoo.com/unlimited/">Yahoo! Music Unlimited - Access over 1 million songs. Try it free.</A></BLOCKQUOTE><DIV><FONT face=Arial size=2><SPAN class=272370717 -27032000>PLEASE READ: The information contained in this email is confidential and </SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=272370717-27032000>intended for the named recipient(s) only. If you are not an intended </SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=272370717-27032000>recipient of this email please notify the sender immediately and delete your </SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=272370717-27032000>copy from your system. You must not copy, distribute or take any further </SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=272370717-27032000>action in reliance on it. Email is not a secure method of communication and </SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=272370717-27032000>Nomura International plc ('NIplc') will not, to the extent permitted by law, </SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=272370717-27032000>accept responsibility or liability for (a) the accuracy or completeness of, </SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=272370717-27032000>or (b) the presence of any virus, worm or similar malicious or disabling </SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=272370717-27032000>code in, this message or any attachment(s) to it. If verification of this </SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=272370717-27032000>email is sought then please request a hard copy. Unless otherwise stated </SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=272370717-27032000>this email: (1) is not, and should not be treated or relied upon as, </SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=272370717-27032000>investment research ; (2) contains views or opinions that are solely those of </SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=272370717-27032000>the author and do not necessarily represent those of NIplc; (3) is intended </SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=272370717-27032000>for informational purposes only and is not a recommendation, solicitation or </SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=272370717-27032000>offer to buy or sell securities or related financial instruments. NIplc </SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=272370717-27032000>does not provide investment services to private customers. Authorised and </SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=272370717-27032000>regulated by the Financial Services Authority. Registered in England </SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=272370717-27032000>no. 1550505 VAT No. 447 2492 35. Registered Office: 1 St Martin's-le-Grand, </SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=272370717-27032000>London, EC1A 4NP. A member of the Nomura group of companies. </SPAN></FONT></DIV>
