From: Halina Monka Subject: Re: [Q]How Can I Remove Some Datafiles..? Date: 1997/08/08 Message-ID: <33EB395B.3FC0@ibm.net>#1/1 References: <33E0C397.5164@hnc.net> <870332860.5533.0.nnrp-4.c2de712e@news.demon.co.uk> Reply-To: hmonka@ibm.net Newsgroups: comp.databases.oracle.server 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@news.demon.co.uk>, Steve > Phelan writes > > > > > >Á¤ÁØ¿µ(Junyoung Jeong) wrote in article <33E0C397.5164@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