Thursday, 5 January 2012

ORA-00059: maximum number of DB_FILES exceeded

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];


No comments:

Post a Comment