Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: need to delete a datafile

Re: need to delete a datafile

From: Cheng-Jih Chen <cjc_at_interport.net>
Date: 2 Oct 1998 12:01:32 -0400
Message-ID: <6v2tcs$cfa$1@interport.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US