Re: Removed Datafile, now I'm stuck!
Date: Fri, 9 Sep 1994 15:29:06 GMT
Message-ID: <CvvCCJ.12qq_at_sue.cc.uregina.ca>
In article <34il0b$opt_at_iris.mbvlab.wpafb.af.mil>, dganote_at_mbvlab.wpafb.af.mil (Debby Ganote) says:
>
>Let me state our DBA just got laid off, I'm the unlucky stand-in.
>
>The problem:
>I altered our temp tablespace by adding a datafile.
>When I was done needing this datafile I went and used the
>unix remove command to delete the datafile.
>Now I'm getting the error "Can't find datafile xxxxx".
>
>How can I get Oracle to delete this datafile from its
>memory? How come there isn't a "delete datafile" when
>there is an "add datafile"?
>
>--
>Debby "I love DBAs, I just don't want to be one"
NEVER KILL OPERATING SYSTEM ENTITIES BEFORE DOING SO THROUGH ORACLE. DROP THE TABLESPACE. BRING THE DATABASE DOWN. KILL THE FILE. AND FINALLY BRING THE DATABASE BACK UP. Received on Fri Sep 09 1994 - 17:29:06 CEST