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
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:
Post a Comment