Re: extending tablespace TEMP

From: Jan Eliasen <eliasen_at_cs.auc.dk>
Date: Tue, 18 Dec 2001 13:22:20 +0100
Message-ID: <Pine.GSO.4.33.0112181319230.17874-100000@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:22:20 CST