Tablespace 및 Datafile 정보 얻기

1.TABLESPACE 정보
1)DBA_TABLESPACES
SQL> select tablespace_name, status from dba_tablespaces;

2)V$TABLESPACE
SQL> select ts#,name from v$tablespace;

2.DATAFILE 정보
1)DBA_DATA_FILES
SQL> select file_name, file_id, tablespace_name from dba_data_files;

2)V$DATAFILE
SQL> select file#, name from v$datafile;

3.Temporary 파일정보
1)DBA_TEMP_FILES
SQL> select file_name, file_id, tablespace_name from dba_temp_files;
2)V$TEMPFILE
SQL> select file#, name from v$tempfile;