Database User for Oracle GoldenGate Processes for TimesTen

Follow these requirements for the database user for Oracle GoldenGate processes:

Note:

Times Ten is only supported as a target.

  • Create a database user that is dedicated to Oracle GoldenGate. It can be the same user for all of the Oracle GoldenGate processes that must connect to a database:

    • Replicat (target database)

    • DEFGEN (target database)

  • To preserve the security of your data, and to monitor Oracle GoldenGate processing accurately, do not permit other users, applications, or processes to log on as, or operate as, the Oracle GoldenGate database user.

  • For Oracle GoldenGate to replicate to a target Oracle TimesTen database, grant SELECT, INSERT, UPDATE, and DELETE on all the target tables to the Replicat database user.

  • For creating heartbeat and checkpoint tables, grant CREATE TABLE to the Replicat database user.