Is It Possible To Replicate The DBID From A Source Database To A Target Database When Replicating Da (Doc ID 2930229.1)

Last updated on JULY 20, 2024

Applies to:

Goal

Is it possible due to a GoldenGate configuration to replicate the DBID value from a source database to a target database when replicating data?

SQL> alter session set container=<pdb name>;

Session altered.

SQL> select dbid,sql_id,plan_hash_value,operation from dba_hist_sql_plan where sql_id in ('3nz32x9gcr9w5') and plan_hash_value in (3043250274) order by dbid,sql_id,id;

  DBID SQL_ID PLAN_HASH_VALUE OPERATION
---------- ------------- --------------- ------------------------------
1879584437 3nz32x9gcr9w5 3043250274 DELETE STATEMENT
1879584437 3nz32x9gcr9w5 3043250274 DELETE
1879584437 3nz32x9gcr9w5 3043250274 COUNT
1879584437 3nz32x9gcr9w5 3043250274 HASH JOIN
1879584437 3nz32x9gcr9w5 3043250274 TABLE ACCESS
1879584437 3nz32x9gcr9w5 3043250274 TABLE ACCESS
2006906039 3nz32x9gcr9w5 3043250274 DELETE STATEMENT
2006906039 3nz32x9gcr9w5 3043250274 DELETE
2006906039 3nz32x9gcr9w5 3043250274 COUNT
2006906039 3nz32x9gcr9w5 3043250274 HASH JOIN
2006906039 3nz32x9gcr9w5 3043250274 TABLE ACCESS

  DBID SQL_ID PLAN_HASH_VALUE OPERATION
---------- ------------- --------------- ------------------------------
2006906039 3nz32x9gcr9w5 3043250274 TABLE ACCESS

12 rows selected.

SQL> select dbid from gv$database;

  DBID
----------
2006906039
2006906039
2006906039
2006906039
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.