SYS@orser> set line 120
SYS@orser> col file_name for a40
SYS@orser> col tablespace_name for a40
SYS@orser> col sizem for a30
SYS@orser> select file_name,tablespace_name,bytes/1024/1024||'M' sizem from dba_data_files;
FILE_NAME TABLESPACE_NAME SIZEM
---------------------------------------- ---------------------------------------- ------------------------------
/u01/app/oracle/oradata/orser/system01.d SYSTEM 720M
bf
/u01/app/oracle/oradata/orser/sysaux01.d SYSAUX 620M
bf
/u01/app/oracle/oradata/orser/undotbs01. UNDOTBS1 755M
dbf
/u01/app/oracle/oradata/orser/users01.db USERS 5M
f
FILE_NAME
SYS@orser> col file_name for a40
SYS@orser> col tablespace_name for a40
SYS@orser> col sizem for a30
SYS@orser> select file_name,tablespace_name,bytes/1024/1024||'M' sizem from dba_data_files;
FILE_NAME TABLESPACE_NAME SIZEM
---------------------------------------- ---------------------------------------- ------------------------------
/u01/app/oracle/oradata/orser/system01.d SYSTEM 720M
bf
/u01/app/oracle/oradata/orser/sysaux01.d SYSAUX 620M
bf
/u01/app/oracle/oradata/orser/undotbs01. UNDOTBS1 755M
dbf
/u01/app/oracle/oradata/orser/users01.db USERS 5M
f
FILE_NAME