Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: [Q]How Can I Remove Some Datafiles..?
Bola Ogunlana wrote:
>
> If you set the datbase into NOARCHIVELOG mode you can try (after making
> sure that anything that resides on the datafile is no longer required or
> has been saved);
>
> alter database datafile '/datafilename' offline drop;
>
>
> In article <870332860.5533.0.nnrp-4.c2de712e_at_news.demon.co.uk>, Steve
> Phelan <stevep_at_toneline.demon.co.uk> writes
> >
> >
> >Á¤ÁØ¿µ(Junyoung Jeong) wrote in article <33E0C397.5164_at_hnc.net>...
> >
> >>Hi.. Everyone.
> >>
> >>Does anyone tell me how can I remove some datafiles?
> >>
> >
> >You can't just delete datafiles on their own, as they are considered to be a
> >part of the tablespace that they are a member of. Basically:
> > - Find the tablespace(s) which own the datafile(s) you want to get rid
> >of.
> > - Find what objects are in those tablespace(s)
> > - If you don't want to keep the objects, then take the tablespace
> >offline, drop it, and delete the datafiles.
> > - If you do wish to keep the objects, export them *before* taking the
> >tablespace(s) offline; then take the tablespace(s) offline, drop them,
> >delete the datafile(s), and then recreate the tablespace(s) with new
> >datafile(s) of the appropriate size. Finally, re-import the objects you
> >exported.
> >
> >Steve Phelan.
> >
> >
>
> --
> Bola Ogunlana
You can drop tablespace and delete datafile(s) using OS command.
However, if your task is to remove some datafile(s) but not entire
tablespace then use export / import .
Halina
Received on Fri Aug 08 1997 - 00:00:00 CDT