ORA-01686: max # files (1023) reached for the tablespace xxxx
09:47:33 sys@Q9DB> alter tablespace part_data add datafile '+DATA1' SIZE 30g autoextend OFF;
alter tablespace part_data add datafile '+DATA1' SIZE 30g autoextend OFF
*
ERROR at line 1:
ORA-01686: max # files (1023) reached for the tablespace PART_DATA
09:51:52 sys@Q9DB>select ts# from v$tablespace where name =upper('part_data');
TS#
----------
8
09:52:26 sys@Q9DB>select count(*) from v$datafile where ts#=8;
COUNT(*)
----------
1023该情况下,该表空间无法增加数据文件,能够做的事情主要有:
1. 通过resize扩展表空间
2. 迁移部分表到其他表空间
3. 清理历史数据
页:
[1]