dba_temp_file vs v$tempfile 2005-10-13 - By zhu chao
V$tempfile just read from controlfile.
While DBA_TEMP_FILES will need to access file header, and it can't lock the
temp file, so it report error.
On 10/13/05, raja rao <raja4list@(protected)> wrote:
>
>
> 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! Music Unlimited - Access over 1 million songs. Try it free.<http://pa
.yahoo.com/*http://us.rd.yahoo.com/evt=36035/*http://music.yahoo.com/unlimited/>
>
>
--
Regards
Zhu Chao
www.cnoug.org <http://www.cnoug.org>
<div>V$tempfile just read from controlfile.</div>
<div>While DBA_TEMP_FILES will need to access file header, and it can't lock
the temp file, so it report error.</div>
<div> </div>
<div><br><br> </div>
<div><span class="gmail_quote">On 10/13/05, <b class="gmail_sendername">raja
rao</b> <<a href="mailto:raja4list@(protected)">raja4list@(protected)</a>>
wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">
<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><span class="ad">
<p>
<hr size="1">
<a onclick="return top.js.OpenExtLink(window,event,this)" href="http://pa.yahoo
.com/*http://us.rd.yahoo.com/evt=36035/*http://music.yahoo.com/unlimited/"
target="_blank">Yahoo! Music Unlimited - Access over 1 million songs. Try it
free.
</a>
<p></p></p></span></blockquote></div><br><br clear="all"><br>-- <br>Regards<br
>Zhu Chao<br><a href="http://www.cnoug.org">www.cnoug.org</a><br>
|
|
