Regresar
-
Título
Migrations facing error ORA-00904: DBMS_RANDOM.VALUE: Invalid Identifier error. Unable to update MERC_MISC_EVENT table -
Descripción
Along a project migration, it facing error ORA-00904: DBMS_RANDOM.VALUE: Invalid Identifier error. Unable to update MERC_MISC_EVENT table. -
Causa
The issue is because of insufficient user privileges. DB STAT user needs access to the dbms_random package. -
Resolución
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;