返回
-
标题
Migrations facing error ORA-00904: DBMS_RANDOM.VALUE: Invalid Identifier error. Unable to update MERC_MISC_EVENT table -
说明
Along a project migration, it facing error ORA-00904: DBMS_RANDOM.VALUE: Invalid Identifier error. Unable to update MERC_MISC_EVENT table. -
原因
The issue is because of insufficient user privileges. DB STAT user needs access to the dbms_random package. -
解决办法
Solution:
1. From a sqlplus or Toad session, log in to Stat DB as SYS and execute the following command:GRANT EXECUTE ON DBMS_RANDOM TO STAT;