dba_temp_file vs v$tempfile 2005-10-13 - By raja rao
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.
<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>
|
|
