RE: Help please

From: Thapliyal, Deepak <DThapliyal_at_ea.com>
Date: Wed, 17 May 2000 10:58:14 -0700
Message-Id: <10500.105871@fatcity.com>

query dba_tables and check if you are the owner of the table you are trying to drop.
alter table <tab> drop column <col>;

deepAk

-----Original Message-----
From: Ngo, Tan [mailto:TNGO_at_eftia.com]
Sent: Wednesday, May 17, 2000 7:50 AM
To: Multiple recipients of list ORACLE-L Subject: Help please

I have tried to drop a table, but keep getting the message ORA 942 table or view does not exist, even though it is there when I described it. In Oracle 8, how do you delete just one column? Thanks for helping.

Tan Ngo
Database Specialist
Direct Line (613)368-4151 (No voice mail) (613)368-4010 Ext. 2281
Cell. (613)286-0033
e-mail: tngo_at_eftia.com <mailto:tngo_at_eftia.com> Received on Wed May 17 2000 - 12:58:14 CDT