Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00059: maximum number of DB_FILES exceeded

534640Oct 11 2006 — edited Apr 9 2012

Hi All,
I m getting the following error
ORA-00059: maximum number of DB_FILES exceeded
As data_files parameter reaches its maximum value.
Can any one tell me how to change the value dynamically. Our 10G ver2 database is 24/7 operational. So i dont want to shutdown and restart. Is there any other solution to change the value.
I tried to change the pfile value and then recreated spfile and again facing the same problem
Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on May 7 2012

Added on Oct 11 2006

#general-database-discussions

28 comments

150,695 views