Re: Help please

From: Suzy Vordos <lvordos_at_uswest.com>
Date: Wed, 17 May 2000 12:02:19 -0600
Message-Id: <10500.105872@fatcity.com>

The object might be a synonym for a table/view, or owned by another schema. Run this query:

select owner, object_name, object_type from all_objects where object_name = '<tablename>' ;

You can drop a column in 8i using alter table.

Suzy

"Ngo, Tan" wrote:
>
> 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 - 13:02:19 CDT