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!

How to increase number of data files parameter

Let me 2b DBAJun 21 2008 — edited Jun 21 2008

Dear All,

I am facing problem in increasing number of data files associated with the DB. I have DB_FILES = 200 and want to set it to 300. DB was started with SPFILE.

Tell me how to increase this parameter. I dont want to stop DB also. I will be thankful if anyone guide me in both ways to stop DB and without stopping it.

Regards
Aqeel Nawaz

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 19 2008

Added on Jun 21 2008

#general-database-discussions

8 comments

1,997 views