Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Section
Column
width5%

 

Column
width95%
Panel
bgColorCCC
dbvrep>list prepare

Note, when the apply process is not run as the default APPLY, then use the "CHOOSE PROCESS" command to choose the appropriate process. For example, if the process is called APPLY2, then use "CHOOSE PROCESS APPLY2"

2) Check that the particular table exists in the Dbvisit Replicate data dictionary table. The following query on the run as the Dbvisit Replicate owner on the target database can be run to verify:

Section
Column
width5%

 

Column
width95%
Panel
bgColorCCC
SQL> select name, obj_ from DBRSOBJ$ where obj_ in (select SOURCE_OBJECT_ID from
DBRSAPPLY_DICT_TABLES);
NAME OBJ_
------------------------------ ----------
DBRSCOL$ 78949
DBRSOBJ$ 78951
DBRSTAB$ 78953
DEPT 74209
EMP 74211
BONUS 74213
SALGRADE 74214
DBRSUSER$ 78955
DBRSV_$DATABASE 78957

Only the tables listed in this table will be replicated. To replicate other tables use the PREPARE command.

3) Are all tables not being replicated or just a subset? If a subset is replicated, please ensure all the tables to be prepared are known to Dbvisit Replicate. Use the "list prepare" to check which tables are known to Dbvisit Replicate.

4) Use the "healthcheck" command to see if all the processes can communicate with each other.