There was a question on the OTN database forum a little while ago about the different between the relative and absolute files numbers for a data file as reported in view dba_data_files - where they appear as file_id and relative_fno - or v$datafile - where they appear as file# and rfile#. In response, someone resurrected a very old posting of mine…
