Re: How to drop a non-system datafile??

Hi Dicky,

    Okay, tell us why you think it didn't work. Incidentally I have had better luck with DROP TABLESPACE <name> INCLUDING CONTENTS.

regards

Jerry Gitomer

Dicky wrote in message <7jms1d$7u1$3_at_imsp009a.netvigator.com>...
>Hi, everybody. I'm new to AIX Oracle. Yesterday I added a wrong raw
device
>into a tablespace. Then I turned the tablespace offline and tried to drop
>the raw device by issuing the following SQL command:
>
>alter database datafile 'name' offline drop;
>
>My database is running in non-archive mode, but according to the manual, a
>datafile can be removed by this command. So anyone can tell me anything I
>did wrong? By the way, why the "remove datafile" buttom in Oracle
>Enterprise Manager is always disabled?
>
>Thanks in advance.
>
>Dicky
>
>
Received on Fri Jun 11 1999 - 08:28:37 CDT