Re: How to remove a datafile from the tablespace?

From: Chris Weiss <weisschr_at_tcimet.net>
Date: Wed, 18 Jul 2001 01:00:19 -0400
Message-ID: <9j34pq$2orc$1@msunews.cl.msu.edu>

You have no choice. To remove the datafile, you muss drop the table space.

The simplest thing is write a script that recreates the table in a new tablespace with a create table As statement. Drop the old tablespace, recreate the old tablespace, move the data back.

You can also export all the objects in the tablespace, drop it, and import the objects back.

Good Luck!
Chris

"Ganesh Kamath" <ganesh.kamath_at_in.bosch.com> wrote in message news:9j33dk$pih$1_at_proxy.fe.internet.bosch.com...
> Hello,
>
> By mistake one datafile has been added to a tablespace, which already had
> one datafile. Now I want to delete the newly added datafile. How do I do
> this? I don't want to drop the tablespace.
>
> Thanks,
> Ganesh Kamath
>
>
Received on Wed Jul 18 2001 - 00:00:19 CDT