Re: dropping data file

From: <satar_at_my-dejanews.com>
Date: Sat, 21 Nov 1998 00:30:52 GMT
Message-ID: <7351jt$k5r$1@nnrp1.dejanews.com>

No, once you create a datafile, you can not drop it.

Satar

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
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

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