select tablespace_name,file_name,autoextensible from dba_data_files;可以查看表空间可以有多个数据文件组成SYSTEM /yfds/app/Administrators/oradata/ORCL/system02.dbf YESSYSTEM /yfds/app/Administrators/oradata/ORCL/system03.dbf YES
显示全部select tablespace_name,file_name,autoextensible from dba_data_files;
可以查看表空间可以有多个数据文件组成
SYSTEM /yfds/app/Administrators/oradata/ORCL/system02.dbf YES
SYSTEM /yfds/app/Administrators/oradata/ORCL/system03.dbf YES
收起