SQL> desc dba_data_files

Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_NAME VARCHAR2(513)
FILE_ID NUMBER
TABLESPACE_NAME VARCHAR2(30)
BYTES NUMBER
BLOCKS NUMBER
STATUS VARCHAR2(9)
RELATIVE_FNO NUMBER
AUTOEXTENSIBLE VARCHAR2(3)
MAXBYTES NUMBER
MAXBLOCKS NUMBER
INCREMENT_BY NUMBER
USER_BYTES NUMBER
USER_BLOCKS NUMBER


SQL> select file_name
2 from dba_data_files
3 where tablespace_name='TEMP';

FILE_NAME
--------------------------------------------------------------------------------
/db07/oradata/DMG/DMGDWHD/temp01.dbf
/db09/oradata/DMG/DMGDWHD/temp02.dbf
/dba/DMG/oradata/DMG/temp03.dbf

SQL> desc dba_temp_files
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_NAME VARCHAR2(513)
FILE_ID NUMBER
TABLESPACE_NAME NOT NULL VARCHAR2(30)
BYTES NUMBER
BLOCKS NUMBER
STATUS CHAR(9)
RELATIVE_FNO NUMBER
AUTOEXTENSIBLE VARCHAR2(3)
MAXBYTES NUMBER
MAXBLOCKS NUMBER
INCREMENT_BY NUMBER
USER_BYTES NUMBER
USER_BLOCKS NUMBER

SQL> select file_name from dba_temp_files;

no rows selected

-------------------------------------------------------------------

Why do the temp files not show up in the 2nd view ?