Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 7 2012
Added on Oct 11 2006
#general-database-discussions
28 comments
146,942 views