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