Problem dropping a view

From: Michael L. Hostbaek <carlos_at_pez.dk>
Date: 30 Apr 2003 13:14:52 GMT
Message-ID: <slrnbavj2c.toi.carlos@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:14:52 CDT