Re: Problem dropping a view

Originally posted by Michael L. Hostbaek
> Group,
>
> I am trying to remove a view from my oracle 8i db.
> This is what happens:
> SQL> drop view nego_offer;
> drop view nego_offer
> *
> ERROR at line 1:
> ORA-00942: table or view does not exist
>
> I know it exists:
> SQL> select * from user_objects;
> Strike a key...
>
> OBJECT_NAME
> SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
> CREATED LAST_DDL_
> ------------------------------ ---------- --------------
> ------------------ --------- ---------
> TIMESTAMP STATUS T G S
> ------------------- ------- - - -
> nego_offer
> 24749 VIEW
> 29-APR-03 29-APR-03
> 2003-04-29:14:21:21 INVALID N N N
>
> Can anyone tell me how to remove it ?
>
> Thanks.
>
> /mich
>
>
> --
> Regards,
> Michael L. Hostbaek
> -= So long, and thanks for all the fish.. =-
That's because some fool created the view with double quotes around the name, which makes it case sensitive. Do this:

DROP VIEW "nego_offer";

--
Posted via http://dbforums.com