Re: why " Alter table emp drop column news_no" doesn't work in Oracle 7.3.* ?

From: Sybrand Bakker <oradba_at_sybrandb.demon.nl>
Date: Sun, 09 Dec 2001 17:25:19 +0100
Message-ID: <k1471u4netfrqd90m4bf8r2b84u4ft4u9q@4ax.com>

On Sun, 9 Dec 2001 09:19:27 -0500, eq418_at_freenet.carleton.ca (Lijun Shi) wrote:

>Hi ,
>
>using Oracle 7.3.x now ( switch fast )
>I did " Alter table emp add ( news_no, number(15,2));" ok .
>but " Alter table emp drop column news_no" doesn't work .
>
>try many times , result is same .
>Also , when I try OCI/C , it gives :
> Connected to ORACLE as scott
>-- ORACLE error when processing OCI function OEXEC, OEXN
>ORA-00905: missing keyword
> Exiting with FAILURE status 1
>when I try OO4O , it gives :
>ErrorNumber()= 8196
>
>" Alter table emp drop column news_no" statement problem ? or others .
>
>thanks
>
>

This variation of the alter table command isn't available in 7.3. It is available in 8i though (not in 8.0)

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Dec 09 2001 - 10:25:19 CST