Re: HOW to increase DB_FILES?

You have reached the MAXDATAFILES limit that was imposed when you created the
database (I believe the default is 32). To increase this limit you will have to recreate your
controlfiles and up the parameter value for maxdatafiles. Briefly, To do this:
0) make sure you have a good backup

1. alter database backup controlfile to trace;
2. edit the .trc file just created in step 1, increase maxdatafiles value; edit initsid.ora increase db_files to equal new maxdatafile parm.
3. shutdown
4. startup nomount
5. run the file edited in step 2.

This documented should be in the manuals somewhere.

DLEUNG wrote:

> HI ,
>
> I am trying to increase the Max.number for DB_FILES in
> oracle 7.32. (solaris platform),
> because I would like to add more files to a tablespace.
>
> BUt I got the following error:
> alter tablespace data05 add datafile '/u9/oradata/CNC01/data05_u9.dbf'
> size 150M
> *
> ERROR at line 1:
> ORA-00059: maximum number of DB_FILES exceeded
>
> -----
> I go to init_instance_name.ora
> and change the db_files from 20 to 40 ,
> and then shutdown oracle and bring up by
> startup.
> BUt it still say the same error.
>
> I call Oracle support,
> they told me instruction of recreate control_files
> to increase MAXDATFILES,
> I can successfully increase the MAXDATAFILES to 60, but it does not
> help me ,
> I try to add one additional (new ) file to a tablespace data05
> , I havethe exact error again.
>
> I really appreciate if anyone can give me some help/hint,
> because ORacle Support is very unhelpful.
> They told me , it should work.
> I am wondering whether MAXDATAFILES has anything to do with DB_FILES?
>
> Please email me directly, because I dont read this news group that
> often
>
> Thank you in advance,
>
> Dominica Leung
>
> dleung_at_cncx.com
>
> or dleung_at_concentric.net
Received on Thu Oct 02 1997 - 00:00:00 CDT