Re: dropping data file

From: <xsun1913_at_my-dejanews.com>
Date: Fri, 20 Nov 1998 16:26:37 GMT
Message-ID: <734575$r06$1@nnrp1.dejanews.com>

In article <7338ni$29q$1_at_nnrp1.dejanews.com>, daud11_at_hotmail.com wrote:
> Hi
>
> If I have a tablespace with 2 or more datafiles, can I drop one of them?
> I have tried dropping a data file using:
> alter database datafile <name> offline drop
> but the data file did not get dropped. My database is in archive log mode.
> I hope someone can explain this to me.
>
> regards
> Daud11
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

Hi,

When a tablespace is created with more than one datafiles and objects are created in the tablespace, database will spread data over these datafiles. That means that a chunk of storage space from each datafile will be used. When the tablespace has been used, you can't simply take a datafile offline and drop it. It has nothing to do with archivelog mode.

Xuening Sun

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Nov 20 1998 - 10:26:37 CST