데이터파일, 테이블스페이스 정보 확인 SQL
backup
set linesize 150 set pagesize 50 col name for a40 col file# for 999,999 col status for a15 col time for a20 select a.file#, a.name, b.status, to_char(b.time,'RRRR-MM-DD:HH24:MI:SS') as time from v$datafile a, v$backup b where a.file#=b.file#;datafile
set linesize 150 set pagesize 50 col tablespace_name for a20 col mb for 999,999 col status for a10 col file_name for a40 select tablespace_name, bytes/1024/1024 mb, status, file_name from dba_data_files order by 4;테이블스페이스
set linesize 150 set pagesize 50 col tablespace_name for a20 col status for a10 col contents for a20 col segment_space_management for a15 col extent_management for a15 select tablespace_name, status, contents, segment_space_management, extent_management from dba_tablespaces;로그파일
set linesize 150 set pagesize 50 col group# for 999 col member for a40 col mb for 9,999,999 col status for a10 col archived for a10 col sequence# for 9,999,999 select a.group#, b.member, a.bytes/1024/1024 MB, a.status, a.archived, a.sequence# from v$log a, v$logfile b where a.group#=b.group# order by 1,2;템프파일
set linesize 200 set pagesize 50 col tablespace_name for a25 col mb for 999,999,999 col file_name for a50 select tablespace_name, bytes/1024/1024 mb, file_name from dba_temp_files
형 퍼가요~ 감솨~
근데 이거 긁으니까 모양 그대로 복사가 되네요
네이버에서도 되나보네요~