查看表空间位置
SELECT tablespace_name,
file_id,
file_name,
round(bytes / (1024 * 1024), 0) total_space
FROM dba_data_files
ORDER BY tablespace_name;
system扩展表空间
alter database datafile '/u01/app/oracle/oradata/XE/system.dbf' autoextend on next 500M maxsize unlimited;
手动设置system表空间大小为9G
alter database datafile '/u01/app/oracle/oradata/XE/system.dbf' resize 9G;
增加system01表空间到system表空间不允许自动增长
alter tablespace system add datafile '/u01/app/oracle/oradata/XE/system1.dbf' size 10G autoextend off;