Niall Litchfield wrote:
>
> 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.
And, if it is production, start looking for a new job!
>
> --
> 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.
> >
--
Ron Reidy
Oracle DBA
Received on Tue Dec 18 2001 - 07:03:18 CST
