truncate/delete fails with "table does not exist" even though the table does exist
I am seeing this in v 11.2.0.4 database
select object_type from dba_objects where object_name = 'GV_COMP_INFO' and owner ='GVDW_OWNER';
OBJECT_TYPE
-------------------
TABLE
select count(1) from gvdw_owner.GV_COMP_INFO;
COUNT(1)
----------
92291
delete from gvdw_owner.GV_COMP_INFO;
delete from gvdw_owner.GV_COMP_INFO
*
ERROR at line 1:
ORA-00942: table or view does not exist
truncate table gvdw_owner.GV_COMP_INFO;
truncate table gvdw_owner.GV_COMP_INFO
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
I am trying to empty a table . Truncate/delete commands are both failing with "table does not exist" although select works and I can see that this table is found in dba_objects. Can anyone suggest what could be the reason for this?