select tablespace_name from DBA_TABLESPACES
order by tablespace_name

OWAPUB
PERFSTAT
PORTAL
SYSTEM
TEMP
22 rows selected
**************************************
***********************************
select tablespace_name from dba_data_files
order by tablespace_name
OWAPUB
PERFSTAT
PORTAL
SYSTEM
56 rows selected
********************************

Now My query is , why this TEMP table space is not coming in second query?I mean why the TEMP tablespace is not coming in dba_data_files table

regards,

praveen