drop view "nego_offer";
"Michael L. Hostbaek" <carlos_at_pez.dk> wrote in message
news:slrnbavj2c.toi.carlos_at_freebsdcluster.dk...
> 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.. =-
>
Received on Wed Apr 30 2003 - 08:34:22 CDT
