테이블스페이스 정보보기-2
작성자 관리자 작성시간 2003-07-23 16:31:53
 

col tablespace_name format a20
col file_name format a40
set linesize 123
set echo on
select t.name tablespace_name, f.name file_name, f.status, f.enabled
from v$tablespace t, v$datafile f
where t.ts# = f.ts#;
set echo off
clear col

SQL> @LABS/tbsinfo2
SQL> select t.name tablespace_name, f.name file_name, f.status, f.enabled
  2  from v$tablespace t, v$datafile f
  3  where t.ts# = f.ts#;

TABLESPACE_NAME      FILE_NAME                                STATUS  ENABLED
-------------------- ---------------------------------------- ------- ----------
SYSTEM              /home/human/oradata/HUMAN/system01.dbf  SYSTEM  READ WRITE
UNDOTBS1            /home/human/oradata/HUMAN/undotbs01.dbf  ONLINE  READ WRITE
CWMLITE              /home/human/oradata/HUMAN/cwmlite01.dbf  ONLINE  READ WRITE


목록 | 입력 | 수정 | 답변 | 삭제