Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: need to delete a datafile
In article <3614D72F.A6EC6771_at_hrb.com>, Kevin Kirkpatrick <kjk_at_hrb.com> wrote:
>I have a datafile that I created a while ago so that I could create a
>rollback segment in that tablespace large enough for what I was doing.
>Now I deleted that rollback segment but I am still left with the
>additional datafile. My other datafile for that tablespace is adequate
>for what I am doing, so how do I get rid of this other datafile safely??
You'll have to drop the tablespace with that datafile in it, then recreate the bits that you dropped. Presumably, this is a rollback segment tablespace, so it should be relatively easy to recreate the wanted rollback segments. Received on Fri Oct 02 1998 - 11:01:32 CDT