Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How to remove a datafile from the tablespace?
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