Hi All ,
I was working on my database and was able to insert /truncate and delete also . however i was not able to create objects . As soon as i created one .i got an error ORA-00210: cannot open the specified controlfile.
How did this happen ???
my database did not have any controlfiles and database was still working . opened a ticket with Oracle and the lady was confused and called me and said its not possible for a database to run but she was not ready to give this to me in writing .
Attached image clearly shows error while trying to create .
i checked and didnt find any controlfiles .
she was unable to tell me how oracle internals works and how this happened .
Does anyone else have an explanation for this .
This is possible .. system was working and without controlfiles .
before saying no ..i would request please do a testing .
