Question - Where are my TEMPFILES, I don't see them in V$DATAFILE or DBA_DATA_FILE?
Answer -
Tempfiles, unlike normal datafiles, are not listed in v$datafile or dba_data_files. Instead query v$tempfile or dba_temp_files:
SELECT * FROM v$tempfile;
SELECT * FROM dba_temp_files;