Re: dba_temp_file vs v$tempfile
- From: zhu chao <zhuchao@xxxxxxxxx>
- To: raja4list@xxxxxxxxx
- Date: Thu, 13 Oct 2005 17:50:54 +0800
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@xxxxxxxxx> 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: 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.<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>
Other related posts:
