Re: extending tablespace TEMP

Well, I think that was always going to be your best bet. I think Niall's posted that there is a 'create daatafile X as Y' command that re-creates exact replicas of a datafile *provided* you have every single archive that was generated since the time of file Y's creation. That might have been an option for you.

The really useful thing to learn out of this is not simply 'never delete a data file', but *why* you can't just do deletes at the O/S level, or 'borrow' other files and hope that Oracle can be fooled into thinking it's the same as the one that went missing. There's a lot of critical information at the header of each datafile that tells Oracle precisely what file it's dealing with, and at what point of database consistency it's at. Simply pinching another file from some place else doesn't work, because that critical information doesn't match what Oracle's expecting to find.

On my site (at the link below), under the 'books' link, there's a 70-page tome on backup and recovery techniques which you may find useful, because successful backup and recovery very largely depends on understanding and working with this file-specific critical information. Anyway, you might find it useful!

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================

"Jan Eliasen" <eliasen_at_cs.auc.dk> wrote in message
news:Pine.GSO.4.33.0112181855310.22463-100000_at_borg.cs.auc.dk...


> On Tue, 18 Dec 2001, Jan Eliasen wrote:

>

> > Oh, and I have added a datafile to the SYSTEM tablespace. Does anyone

know


> > how I delete it from the tablespace again? I have accidently deleted the

> > file on the harddrive, but I can't seem to find a way to remove it from

> > the tablespace?!?

> I ended up erasing it all, and reinstalling oracle. It works just fine...

> and I'll never ever again delete a datafile :-)

>

> Thanks for all the support.

>

> --

> Eliasen Jr.

>