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

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

You should read the docs...this "feature" was not available until 8i.

-- 
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.