Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: dba_temp_file vs v$tempfile
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_at_yahoo.com> 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> -- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 13 2005 - 04:53:08 CDT