Temporary tablespace data file

From DB Optimizer
Jump to: navigation, search

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