Hi,
I am using Oracle12.1. I was wondering if the temporary tablespace is corrupted. But when I try to find it I get no results from this queries :
SQL> select * from dba_temp_files;
no rows selected.
SQL> select * from v$tempfile;
no rows selected.
Is this normal ? Is there another query to use ?
Regards,
Christian