Re: Removed Datafile, now I'm stuck!

> 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".

Suffice it to say, never, ever do this.

To correct your more immediate problem, you will need to drop and recreate the tablespace. Assuming that there isn't anything permanent in your tablespace, this should be relatively simple. (Startup nomount, etc.)  

> 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"?

Quite frankly, neither adding nor dropping datafiles are considered good practice once the database has been created. Adding datafiles fragments your tablespaces, and since they can't be dynamically removed, every time you need to add a datafile, you should rethink your entire database structure. Received on Sat Sep 10 1994 - 18:57:51 CEST