RE: Help please (CAN NOT DROP TABLE)

From: Thomas Harleman <tharleman_at_iquest.net>
Date: Wed, 17 May 2000 14:09:37 -0500
Message-Id: <10500.105881@fatcity.com>

You first must make sure it is a table.
Select from ALL_OBJECTS to make sure.

Tom Harleman
11080 Willowmere Dr.
Indianapolis, IN 46280
317-844-2884 Home
317-843-9122 Home Office

ThinkFast CONSULTING, Inc. (formerly Pinnacle Solutions) Technical Consultant
3500 DePauw Blvd. Suite 2071
Indianapolis, IN 46268
tharleman_at_thinkfast.com
317-334-1317 Office
317-334-1301 Fax

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Ngo, Tan Sent: Wednesday, May 17, 2000 9: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 - 14:09:37 CDT