Maybe the real table is in some other schema and you
have a synonym for that. So if you want to drop the
table log in as that table owner and do it.
Alroy
- Thomas Harleman <tharleman_at_iquest.net> wrote: >
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-----
> Sent: Wednesday, May 17, 2000 9:50 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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>
>
> --
> Author: Thomas Harleman
> INET: tharleman_at_iquest.net
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
Do You Yahoo!?
Get your free @yahoo.co.uk address at
http://mail.yahoo.co.uk
Received on Thu May 18 2000 - 01:06:12 CDT