Hai sonali,

If the no.of datafile limited is reched.

You have to do the following command,

1. alter database backup controlfile to trace;

then

2. You have to edit the latest trace file.

you change the parameter like

maxdatafiles 100

then
3. start the database in nomount state,

4. Execute the modified trace file.

5. alter database open;

This is the method you have do it.


If you have any problem in the same thing just mail me

shankar_gk@hotmail.com;shankar_gk@usa.net;
kgshangs@yahoo.com,


Bye,


Sonali.