异常:
ORA-01658: 无法为表空间 TS_XXX 中的段创建 INITIAL 区
解决方案:
1、查看表空间使用情况;
SELECT a.tablespace_name "TABLESPACE_NAME",
total / (1024 * 1024) "TOTAL(M)",
free / (1024 * 1024) "FREE(M)",
(total - free) / (1024 * 1024) "USED(M))",
round((total - free) / total, 4) * 100 "USAGE RATE%"
FROM (SELECT tablespace_name, SUM(bytes) free
FROM dba_free_space
GROUP BY tablespace_name) a,
(SELECT tablespace_name, SUM(bytes) total
FROM dba_data_files
GROUP BY tablespace_name) b
WHERE a.tablespace_name = b.tablespace_name
2、查看已增加的数据文件;
select * from dba_data_files t where t.TABLESPACE_NAME ='TS_XXX'
3、增加数据文件;
详细增加数据文件的规范可见官网https://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_3002.htm#SQLRF01002
示例:
alter tablespace TS_FFS add datafile '/u01/app/oracle/oradata/orcl/TS_XXX01.ora' SIZE 128M AUTOEXTEND OFF;