Table alteration- impacts to supplemental logging.
BugsJul 19 2012 — edited Jul 19 2012Guys,
Few of the tables in our database are set for supplemental logging for the purpose of Change data capture.
Now, I'm trying to understand the impacts of the scenarios below:
Scenario -1: Table "X" set for supplemental logging on its PK columns is now altered to bring in 2 addditional columns. The newly added columns will be part of existing composite Primary keys.
=> It requires the actions below:
1) Drop existing supplemental log group.
2) Create new supplemental log group with all Primary Keys.
Scenario -2: Table "Y" set for supplemental logging on its PK columns is now altered to bring in 2 addditional columns. The newly added columns will NOT be part of Primary keys.
=> This requires no action.
Please correct me if I'm wrong. I'm not all that sure of the action required for scenario-2.
Regards,
Bhagat