Path: news.easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!nntp.abs.net!uunet!dca.uu.net!bassoon.!rain.i-cable.com!not-for-mail
From: "Simon" <sychan98@excite.com>
Newsgroups: comp.database.oracle,comp.databases.oracle.misc,comp.databases.oracle.server
Subject: Re: why " Alter table emp drop column news_no" doesn't work in Oracle 7.3.* ?
Date: Thu, 13 Dec 2001 13:17:59 +0800
Organization: Another Netscape Collabra Server User
Lines: 28
Message-ID: <9v9do2$qeq1@rain.i-cable.com>
References: <77EN7.7865$z8.1954722@news02.optonline.net> <e5yQ7.16403$wL4.19720@rwcrnsc51> <9uvrq8$fne$1@freenet9.carleton.ca>
NNTP-Posting-Host: 203.83.67.82
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Xref: easynews comp.database.oracle:7129 comp.databases.oracle.misc:73704 comp.databases.oracle.server:127988
X-Received-Date: Wed, 12 Dec 2001 23:03:28 MST (news.easynews.com)

drop column is feature in Oracle 8....


"Lijun Shi" <eq418@freenet.carleton.ca> wrote in message
news:9uvrq8$fne$1@freenet9.carleton.ca...
> 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
>
>
>