SQL> desc dba_data_files
名前
---------------------------------
FILE_NAME
FILE_ID
TABLESPACE_NAME
BYTES
BLOCKS
STATUS
RELATIVE_FNO
AUTOEXTENSIBLE
MAXBYTES
MAXBLOCKS
INCREMENT_BY
USER_BYTES
USER_BLOCKS
ONLINE_STATUS
SQL>
SQL> set pages 1000
SQL> set line 100
SQL> column tablespace_name format a15
SQL> column file_name format a50
SQL> select tablespace_name,file_name,bytes from dba_data_files;
TABLESPACE_NAME FILE_NAME BYTES
--------------- -------------------------------------------------- ----------
USERS C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF 104857600
UNDOTBS1 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF 26214400
SYSAUX C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DBF 692060160
SYSTEM C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF 377487360
SQL>
|