为表空间增加数据文件的时候报:
ORA-00059: maximum number of DB_FILES exceeded
SQL> show parameter db_files;
NAMETYPEVALUE
------------------------------------ ----------- ------------------------------
db_filesinteger200
SQL> alter system set db_files=512 scope=both;
alter system set db_files=512 scope=both
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
还不能直接改。
SQL> alter system set db_files=1024 scope=spfile;
ORA-00059: maximum number of DB_FILES exceeded
SQL> show parameter db_files;
NAMETYPEVALUE
------------------------------------ ----------- ------------------------------
db_filesinteger200
SQL> alter system set db_files=512 scope=both;
alter system set db_files=512 scope=both
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
还不能直接改。
SQL> alter system set db_files=1024 scope=spfile;
System altered.
原来数据库默认表空文件个数的最大值是200。