Re: how to drop datafile?

From: Sang Ryung Lee <srlee_at_shinsegi.com>
Date: Tue, 19 Jan 1999 18:30:53 +0900
Message-ID: <36A450CC.4F92BA83@shinsegi.com>

Hi, Steve

I think that Oracle dosen't have a "drop datafile" function. It is impossible to drop one of the datafiles that composes a tablespace without losing the data.

I don't know why you want to drop one of the datafiles?

Bye.
S.R.Lee
.

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
Received on Tue Jan 19 1999 - 03:30:53 CST