Re: Delete a datafile from a tablespace

"Kevin A Lewis" <Kevin_A_Lewis_at_Hotmail.com> wrote in message news:KedKa.31$6W.9_at_newreader.ukcore.bt.net...
> Is that quite true?
>

Perfectly true.

> I thought you could do the offline drop thing and then look at rebuilding
> the controlfile from a script based on the 'alter database backup
> controlfile to trace' output. Making sure of course that you leave out the
> offending file.
>

Try it. The file comes back listed as missing! That's because the controlfile is not the only place where these details are stored: SYS.FILE$ also gets an entry. And if you want to start doing deletes from there ... well, let's just say that would be 'unsupported'.

> Not possible unless you can handle the implications of doing this though.
>
> Personally I would think about renaming the file (and possibiliy moving
it)
> to make it fit in with the conventions of the Tablespace is has
accedentally
> been added to. Then it can be sized up for use as appropriate to the
> requirements in that Tablespace. Then add a new (and correctly named) file
> for the originally intended Tabelspace. Or am I just being dense!
>

No, exactly. Since removal of the file is a non-possibility, live with it. Rename it as you suggest, resize it as appropriate, but learn to love it, because you're stuck with it!

;-* Received on Wed Jun 25 2003 - 06:15:15 CDT