Re: How to delete unnecessary datafiles

From: Richard Armstrong <StateOArt_at_worldnet.att.net>
Date: Thu, 3 Jun 1999 12:49:01 -0600
Message-ID: <7j6ii2$khk$1@bgtnsc01.worldnet.att.net>

You could have created a new tablespace for the new datafiles. Then you could copy the tables to the new tablespace, and eliminate the old tablespace. This is just about as time consuming as doing the exports, and is more prone to mistake.

I would keep the old datafiles... What are they hurting? Since you only have one tablespace, the only easy way to remedy your situation is to do a full export, restructure the tablespace, and import the tables.

--

---

Richard Armstrong
State Of The Art Consulting, Inc.
http://www.stateoart.com

---

Diablo <diabl_at_email.com> wrote in message news:7j5orq$fvi$1_at_usenet49.supernews.com...
> We got in oracle 8.03 only one tablespace that holds tables but due to
space
> requirements, I got to add new datafiles to the tablespace. But now, we
> added a new and 9GB disk for storage and added a 4 mb datafile to the same
> tablespace.I want to get rid of the old ones but I cannot dare or have
time
> to practice full importing tables. Is it possible emptying the old
datafiles
> and transferring the tables data to the new datafile in order to delete
the
> old datafiles?
> Thanks in advance..
>
> Kayhan Ketenci
> IS Administrator
> HTP Research
>
>
Received on Thu Jun 03 1999 - 13:49:01 CDT