SQL> select tablespace_name from dba_temp_files; TABLESPACE_NAME ------------------------------ TEMP TEMP SQL> select temporary_tablespace from dba_users where username='ADMN'; TEMPORARY_TABLESPACE ------------------------------ TEMP SQL> select count(*) from dba_temp_files; COUNT(*) ---------- 2 SQL> desc dba_temp_files; Name Null? Type ----------------------------------------- -------- ---------------------------- FILE_NAME VARCHAR2(257) 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,TABLESPACE_NAME from dba_temp_files; FILE_NAME ------------------------------ TABLESPACE_NAME ----------------------------- /u03/PRODDB/oradata/temp02.dbf TEMP /u03/PRODDB/oradata/temp01.dbf TEMP |