Just a little addition to that:
Check the db_files parameter in your spfile and subtract from 202 (the 'odd' file number you saw) and the result is the tempfile number
Regards
Jonathan Lewis http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis
The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Cost Based Oracle: Fundamentals http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
It's your temp file.
Regards, Brandon
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ray Feighery
Now I thought that the p1 and p2 values pointed to the file# and block# values. However, there is no file with an id of 202 in this database:
--------------------------------------------------------------------------------
No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.407 / Virus Database: 268.12.9/458 - Release Date: 27/09/2006
-- //www.freelists.org/webpage/oracle-l