-
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
-
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).