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

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to remove a datafile from the tablespace?

Re: How to remove a datafile from the tablespace?

From: Ganesh Kamath <ganesh.kamath_at_in.bosch.com>
Date: Wed, 18 Jul 2001 10:55:18 +0530
Message-ID: <9j36l9$bdk$1@proxy.fe.internet.bosch.com>

But the tablespace that I am talking about is TEMPORARY_DATA (created by default).

Is it ok to drop this tablespace? I am not sure...I a new to Oracle.

Thanks.
Ganesh Kamath

"Chris Weiss" <weisschr_at_tcimet.net> wrote in message news:9j34pq$2orc$1_at_msunews.cl.msu.edu...  You have no choice. To remove the datafile, you muss drop the tablespace.  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:25:18 CDT

Original text of this message

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