dba_temp_file vs v$tempfile 2005-10-13 - By amit.sharma@(protected)
Whats status does it shows you for it?
Regards
Amit
-- --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>
</BODY></HTML>
|
|
