SQL> select tablespace_name,file_name from dba_data_files;
TABLESPACE_NAME FILE_NAME
------------------------------ ------------------------------
SYSTEM /u01/app/oracle/system.dbf
SYSAUX /u01/app/oracle/sysaux.dbf
UNDOTBS /u01/app/oracle/undotbs.dbf
USERDATA /u01/app/oracle/userdata.dbf
Temp tablespace will not show under dba_data_files it will show under dba_temp_files.
SQL> select TABLESPACE_NAME,FILE_NAME from dba_temp_files;
TABLESPACE_NAME FILE_NAME
------------------------------ ------------------------------
TEMPX /u01/app/oracle/tempx.dbf
TABLESPACE_NAME FILE_NAME
------------------------------ ------------------------------
SYSTEM /u01/app/oracle/system.dbf
SYSAUX /u01/app/oracle/sysaux.dbf
UNDOTBS /u01/app/oracle/undotbs.dbf
USERDATA /u01/app/oracle/userdata.dbf
Temp tablespace will not show under dba_data_files it will show under dba_temp_files.
SQL> select TABLESPACE_NAME,FILE_NAME from dba_temp_files;
TABLESPACE_NAME FILE_NAME
------------------------------ ------------------------------
TEMPX /u01/app/oracle/tempx.dbf
No comments:
Post a Comment