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

From: Steve Phelan <stevep_at_toneline.demon.co.uk>
Date: 1997/07/31
Message-ID: <870332860.5533.0.nnrp-4.c2de712e@news.demon.co.uk>#1/1

Á¤ÁØ¿µ(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. Received on Thu Jul 31 1997 - 00:00:00 CDT