Posted by –1. Datafile
SQL> select tablespace_name, bytes/1024/1024 MB, file_name from dba_data_files;
TABLESPACE_NAME MB FILE_NAME ———————————————————————————————————————————————————–
SYSTEM 2048 +DATA/mndemu/datafile/system.262.737329537
UNDOTBS1 3072 +DATA/mndemu/datafile/undotbs1.263.737329715
SYSAUX 2048 +DATA/mndemu/datafile/sysaux.264.737329987
UNDOTBS2 3072 +DATA/mndemu/datafile/undotbs2.266.737330195
USERS 1024 +DATA/mndemu/datafile/users.267.737330457
TS_EMUMA01 3000 +DATA/oradata/emu_mail_data.dat
TS_EMUPO01 10240 +DATA/oradata/emu_portal_data2.dat
TS_EMUHA01 6000 +DATA/oradata/emu_haksa_data.dat
TS_EMUEL01 12300 +DATA/oradata/emu_elearn_data.dat
IS_EMUPO01 3000 +DATA/oraindx/emu_portal_index.dat
IS_EMUHA01 2000 +DATA/oraindx/emu_haksa_index.dat
–2. Tempfile
SQL> select file_name from dba_temp_files;
FILE_NAME
—————————————————————–
C:\ORACLE\ORADATA\GILNET\TEMP01.DBF
–3. Control 파일
SQL> select name from v$controlfile;
NAME
—————————————————————–
C:\ORACLE\ORADATA\GILNET\CONTROL01.CTL
C:\ORACLE\ORADATA\GILNET\CONTROL02.CTL
C:\ORACLE\ORADATA\GILNET\CONTROL03.CTL
–4. REDO LOGFILE
SQL> select member from v$logfile;
MEMBER
—————————————————————–
C:\ORACLE\ORADATA\GILNET\REDO03.LOG
C:\ORACLE\ORADATA\GILNET\REDO02.LOG
C:\ORACLE\ORADATA\GILNET\REDO01.LOG