Temporary tablespace data file
Oracle Temp File #s How can we have a file# 202 ?
SQL> select file# from v$datafile; FILE# ---------- 1 2 3 4 5 6 7 8
Temporary File#’s = Db_files + file#
SQL> show parameters db_files NAME VALUE ---------- ------------- db_files 200
File# 202 = temp File# #2
SQL> select file# from v$tempfile; FILE# ---------- 2 1