Re: Urgent help needed. Datafile dropped from OS. Please help.

On Nov 18, 6:38 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> On Tue, 18 Nov 2008 06:36:44 -0800, Mark D Powell wrote:
> > Check to see if the tablespace is still defined to the system. If it is
> > then use the alter tablespace drop datafile command to drop the missing
> > file.
>
> > Next use drop tablespace including contents to remove the tablespace.
>
> Have you noticed that the file name contains the word "undo"?

Have you noticed the word "development" in the OP? :-)

This will give some weight to the argument that even development databases are somebodies production, but even so, there is more latitude for development environments, right? There ought to be some procedures for this sort of meltdown. Privilege given to developers is another canonball of waxy worms.

On the other hand, the lesson they really need to learn is they need some capable DBA if they are using RAC!

jg

--
@home.com is bogus.
"Nobody was trapped on the escalator." - Local ABC affiliate
newsreader makes joke that no one gets, after story about 5 people
injured on Universal City Walk escalator reversal.  This distracts
other newsreader, who then says "Moron college students... more on the
college students who..."