If there was no data in the datafile - and thats a pretty big if - you might
get away with 'alter database datafile 'your file' offline drop;' However it
is unlikely that there was no data in the file and the tablespace involved
is the system tablespace. IF you are in this situation I.E. A corrupt system
tablespace and no backup then if the db is for home use you should destroy
the database and start again. If you are talking about a production database
it is time to call Oracle support for some (expensive) options.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Jan Eliasen" <eliasen_at_cs.auc.dk> wrote in message
news:Pine.GSO.4.33.0112181319230.17874-100000_at_borg.cs.auc.dk...
> On Tue, 18 Dec 2001, Howard J. Rogers wrote:
>
> > You can never remove a file from a tablespace once it's been added.
You'll
> > need to retrieve the file from backup, and perform recovery to it.
> I'm afraid I have no backup of it. I added the file to the tablespace just
> to try it, and couldn't remove it again.. so I deleted it on the
> harddrive. What do I do now? Oracle wont start up properly. I have tried
> just to put an empty file in the place, but Oracle doesn't just change it
> to a format which can be used :-/ I have also tried to add a third
> datafile to the tablespace and just copy that file to the filename of the
> second file which I deleted... didn't work either.
>
> Please help.
>
> --
> Eliasen Jr.
>
Received on Tue Dec 18 2001 - 06:40:40 CST
