The “show config” will provide the names of tables that are in replication. However, if the file is large, such listing will scroll thru the screen and it would be tedious to spot a particular table in that scenario. So, we can check the list of the tables or summary in the config_log file which will be generated or shown at the bottom of the output. There is no sp_ctrl command that would name the tables in replication. The following is a sample output of “show config”:
sp_ctrl > show config
Tables Replicating with Key:
"SHA92"."CDCTABLE" KEY: NUM_COL
.
.
File Name :cdcconfig
Datasource :ORA11GR2
Activated :11-Jul-19 15:02:59
Actid :12
Total Objects :xx
Total Objects Replicating :nn
Total Objects Not Replicating :0
View config summary in /home/paul/p92139-11g/var/log/ORA11GR2_config_log
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center