Re: How to drop a datafile?

From: Cheong <ccheong_at_my.lhsgroup.com>
Date: Thu, 22 Apr 1999 12:26:18 +0800
Message-ID: <371ea20e@news.lhsgroup.com>

Forgot to say, I do not want to drop the tablespace. I only want to drop the newly added datafile. It is possible?

Cheong wrote in message <371e8982_at_news.lhsgroup.com>...
>Hi:
>
>I have added a datafile to abc non-system tablespace, and decided that I
>should drop the datafile. I am in startup restrict mode, so I know for sure
>that the newly added datafile is "clean".
>
>Can I:
>
>ALTER DATABASE my_db
>DATAFILE 'abc' OFFLINE DROP?
>
>TIA
>Cheong
>
>
Received on Wed Apr 21 1999 - 23:26:18 CDT