본문 : http://www.ischo.net -- 조인상 //시스템 엔지니어

+++++++++++++++++++++++++++++++++++++++++++++++++++++++


1. mount 단계에서 조회가능

v$datafile
sql> SELECT name,status FROM v$datafile;

v$controlfile
sql> SELECT name FROM v$controlfile;

v$logfile
sql> SELECT member FROM v$logfile;


datafile과 해당하는 테이블스페이스 조회
sql> SELECT t.name tablespace, f.name datafile
  2> FROM v$tablespace t, v$datafile f
  3> WHERE t.ts# = f.ts#
  4> ORDER BY datafile;


2. open 단계에서 조회가능

DBA_DATA_FILES
sql> SELECT file_name, tablespace_name FROM dba_data_files;


DBA_TABLESPACES
sql> SELECT tablespace_name, status FROM dba_tablespaces;