Delete a datafile?

chuckh_at_ix.netcom.com (Chuck Hamilton) wrote:

ALTER DATABASE DATAFILE 'filespec' OFFLINE DROP

>How do you delete a datafile from a tablespace?
>
>Is there an easy way if you know that no extents have been allocated
>from that datafile?
>--
>Chuck Hamilton
>chuckh_at_ix.netcom.com
>
>Never share a foxhole with anyone braver than yourself!
>

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Gordon E. Hooker MACS PCP
25 Clarke Street Ripley Queensland Australia Phone 61-7-32940555
Email gordonh_at_acslink.net.au
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ It is far far better to remain silent and appear a fool then to open ones mouth and remove all doubt.

Anon. Received on Tue Jan 02 1996 - 00:00:00 CET