Home » Server Options » Streams & AQ » Adding new Column in CDC table (Oracle 9i release 2 on HPUX 64 bit)
Adding new Column in CDC table [message #539260] Thu, 12 January 2012 10:30
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
i need to add new column in change data capture table so that it reflect the change in this corresponding column in production.

There are 38 cdc tables

Could any one tell me steps required to add new column in one of the CDC tables so that it will not disturb the current data of changing CDC table and will not disturb other CDC tables.

Report message to a moderator

Previous Topic: Streams - Multiple Capture process
Next Topic: what does add supplemental log data do
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Mar 20 11:18:29 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.