how to increase the datafiles

[cravi]

Hi Halo

To increase the number of datafiles I have some procedure somewhere i read.But i am not sure about this.Please look into this and give me your advice.

1.Alter database backup controlfile to trace;

2.edit the trace file and change the number of db_files and save as xxx.ctl

3.shutdown the datase.

4.startup nomount

5.run the file i.e., @xxx.ctl

6.alter database open.

Please let me know about this

Thanks
Ravi

[carp]

Cravi -
The process you are outlining is the change the value of max_datafiles.
To change the value of db_files, you just need to change the value in init.ora and bounce the instance (unless your current value is the same as max_datafiles).