Re: How to remove a datafile from the tablespace?

As long as it is a property TEMPORARY tablespace, you can drop it and recreate it at instance startup.

startup restrict; (to keep people out)
drop tablespace xxx;
create tablespace xxxx .....;
alter system disable restricted session;

"Ganesh Kamath" <ganesh.kamath_at_in.bosch.com> wrote in message news:9j36l9$bdk$1_at_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 - 05:24:14 CDT