Database Administration (MOSC)

MOSC Banner

truncate/delete fails with "table does not exist" even though the table does exist

edited Dec 19, 2015 10:01AM in Database Administration (MOSC) 4 commentsAnswered

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center