Return
-
Title
Compare error "1031 calling de_table_get_obj_id " -
Description
The declt log shows the below errordeclt 2015-11-30 19:56:48.600665 16142 3069509520 Error: rc=1031declt 2015-11-30 19:56:48.600698 16142 3069509520 Error 1031 calling de_table_get_obj_id (de_table_ask_obj_id,L1252)declt 2015-11-30 19:56:48.600708 16142 3069509520 Error - unable to get object id, rc=1031declt 2015-11-30 19:56:48.600708 16142 3069509520 Exiting.................. -
Cause
Compare client encountered ORA-1031 while executing the below select statementSELECT o.obj#, t.property, t.flags, o.flagsFROM sys.obj$ o, sys.user$ u, sys.tab$ tWHERE u.user# = o.owner# AND o.obj# = t.obj#AND o.name='XXXX' AND u.name ='ABCD';Replace XXXX and ABCD with owner and table name -
Resolution
Resolution:Grant permission on SELECT_CATALOG_ROLEgrant select on SYS.user$ to SELECT_CATALOG_ROLE;