GoldenGate – Error (904, ORA-00904: : Invalid Identifier) Selecting Data in ORAUTIL_getCurrentSCN()

GoldenGate – Error (904, ORA-00904: : Invalid Identifier) Selecting Data in ORAUTIL_getCurrentSCN()

Extract process return error (904, ORA-00904: : invalid identifier) selecting data in ORAUTIL_getCurrentSCN()

  • The goldengate user has been granted the DBA role in database,
  • And has execute permissions on DBMS_FLASHBACK
  • grant execute on DBMS_FLASHBACK to <gguser>

In some environments, this issue can be resolved by just giving the execute on dbms_flashback to <ggsuer> without granting DBA role.
But the accepted approach is still to grant the DBA role in database to the user.

  • January 21, 2019 | 18 views
  • Comments