Zurück
-
Titel
Migrations facing error ORA-00904: DBMS_RANDOM.VALUE: Invalid Identifier error. Unable to update MERC_MISC_EVENT table -
Beschreibung
Along a project migration, it facing error ORA-00904: DBMS_RANDOM.VALUE: Invalid Identifier error. Unable to update MERC_MISC_EVENT table. -
Ursache
The issue is because of insufficient user privileges. DB STAT user needs access to the dbms_random package. -
Lösung
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;