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.


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


Current Time: Thu Apr 17 10:44:01 CDT 2014

Total time taken to generate the page: 0.10801 seconds