Re: How do U remove datafiles.

From: Archana Rajagopal <archana_at_tsp-inc.com>
Date: Thu, 25 Feb 1999 18:14:16 -0500
Message-ID: <7b4lhs$rg0$1@news1.epix.net>

Hi Simeon,
Verbatim from Oracle documentation in OTNetwork.

"When you drop a tablespace, only the file pointers in the control files of the associated database are dropped. The datafiles that constituted the dropped tablespace continue to exist. To free previously used disk space, delete the datafiles of the dropped tablespace using the appropriate commands of your operating system after completing this procedure."

Regards,
Sudhakar Balasankar
mailto:sudhakar_at_tsp-inc.com
http://www.tsp-inc.com
Ph: 888-332-6602
Fax: 888-332-6603

Simeon Bailey wrote in message <36D4EE9D.A54BEF0_at_astracon.com.au>...
>Hi ,
> After I drop a tablespace the associated datafile remains. Is there
>any way to force Oracle to remove this file, rather than doing it
>manually?
>
>Thanks
>S.
>
>
Received on Thu Feb 25 1999 - 17:14:16 CST