Thursday, June 8, 2017

Increase Maximum Number of Data Files in Oracle Database

ORA-00059: maximum number of DB_FILES exceeded

SQL> show user
SYS

SQL> show parameter db_files

NAME                                     TYPE      VALUE
------------------------------------ ----------- ------------------------------
db_files                                     integer    200

SQL> alter system set db_files = 256 scope = spfile;

SQL> shutdown immediate
SQL> startup
SQL> show parameter db_files


NAME                                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
db_files                                    integer     256

No comments:

Post a Comment