Sunday, June 6, 2021

Adgrants.sql errors with 'ORA-00942: table or view does not exist' for dbmshp_runs and other objects

 Adgrants.sql errors with 'ORA-00942: table or view does not exist' for dbmshp_runs and other objects


While running adgrants.sql 

ORA-00942: table or view does not exist

when trying to drop Objects :

dbmshp_runs
dbmshp_function_info
dbmshp_parent_child_info
dbmshp_runnumber


Solution -:

After trying to drop these objects, dbmshptab.sql run by adgrants.sql creates them, so the errors while dropping them can be ignored.
 


No comments: