Re: how to drop datafile?

From: <rspeaker_at_my-dejanews.com>
Date: Tue, 19 Jan 1999 18:11:48 GMT
Message-ID: <782hsq$bm5$1@nnrp1.dejanews.com>

one way to do this would be to export the entire tablespace, drop it, recreate it with the number/size datafiles you want, then reimport the data. I don't know of any way to drop a single datafile.

HTH,
Roy

In article <780bud$fu7$1_at_nnrp1.dejanews.com>, steve_young_at_my-dejanews.com wrote:
> I have a 10GB tablespace consist of 10 1GB datafiles. Each are partially
> filled(from what I see in storage manager). How can I drop one of the
> datafile without losing the data?
>
> Thanx in advance.
>
> Steve
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Jan 19 1999 - 12:11:48 CST