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