Re: need to delete a datafile

From: <satar_at_my-dejanews.com>
Date: Fri, 02 Oct 1998 19:37:27 GMT
Message-ID: <6v3a1l$5ia$1@nnrp1.dejanews.com>

I believe your only option is to drop and re-create the tablespace.

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??
>
> Thanks
> Kevin
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Oct 02 1998 - 14:37:27 CDT