SQL> create tablespace 0362_363 DATAFILE '/oradata/rman/data/0362_01.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 150M
*
ERROR at line 1:
ORA-00059: maximum number of DB_FILES exceeded
SQL> show parameter db_files
db_file_name_convert string 0
db_files integer 200
Cause: You are trying add more datafile then limit. the limit is 200 only.
Solution:
SQL>alter system set db_files = 256 scope = spfile;
SQL>shutdown immediate;
SQL> startup
SQL> sho parameter db_files
db_files integer 256
now ...
SQL>create spfile from pfile [path];
*
ERROR at line 1:
ORA-00059: maximum number of DB_FILES exceeded
SQL> show parameter db_files
db_file_name_convert string 0
db_files integer 200
Cause: You are trying add more datafile then limit. the limit is 200 only.
Solution:
SQL>alter system set db_files = 256 scope = spfile;
SQL>shutdown immediate;
SQL> startup
SQL> sho parameter db_files
db_files integer 256
now ...
SQL>create spfile from pfile [path];
No comments:
Post a Comment