SYS @ prod >select file_id,file_name,tablespace_name,bytes/1024/1024 from dba_data_files; FILE_ID FILE_NAME TABLESPACE_NAME BYTES/1024/1024---------- -------------------------------------------------- ------------------------------ --------------- 1 /u01/app/oracle/oradata/prod/system01.dbf SYSTEM 1024 2 /u01/app/oracle/oradata/prod/lx01.dbf LX01 30 3 /u01/app/oracle/oradata/prod/sysaux01.dbf SYSAUX 260 4 /u01/app/oracle/oradata/prod/users01.dbf USERS 158.75 5 /u01/app/oracle/oradata/prod/test01.dbf TEST 7 6 /u01/app/oracle/oradata/prod/test02.dbf TEST 5 8 /u01/app/oracle/oradata/prod/test04.dbf TEST 5 7 /u01/app/oracle/oradata/prod/undotbs02.dbf UNDOTBS2 100 9 /u01/app/oracle/oradata/prod/lx02.dbf LX02 30 10 /u01/app/oracle/oradata/prod/lx03.dbf LX03 30 11 /u01/app/oracle/oradata/prod/lx04.dbf LX04 30 12 /u01/app/oracle/oradata/prod/index01.dbf INDEXES 50 13 /u01/app/oracle/oradata/prod/perftbs1.dbf PERFTBS 100
转载于:https://www.cnblogs.com/iyoume2008/p/4690704.html
