Re: Removed Datafile, now I'm stuck!

In article <34il0b$opt_at_iris.mbvlab.wpafb.af.mil> dganote_at_mbvlab.wpafb.af.mil (Debby Ganote) writes:
>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"
 You have not specified whether you are getting the error during runtime or at the time of starting up the database. If your database is still up and
you do not have any data in the tablespace and is used only as a temporary tablespace , then you can take that tablespace offline, then drop that tablespace and re-create the same. If your problem is not getting Oracle to startup due to the deletion of the file, then follow this procedure.
sqldba - startup nomount ;
alter database mount exclusive;
alter database datafile 'xxxxxx'(the name of the datafile you deleted with the full pathname) offline;
alter database open;

Now drop the tablespace and re-create it .

You cannot delete any of your datafiles.Only way is to drop the tablespace and re-create them.

Also please specify the version of the database while posting such errors.

-- 
Ramesh Krishnamurthy