Re: [Q]How Can I Remove Some Datafiles..?

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