OraFAQ Forum: Streams & AQ » Change data capture and alter table add columns

Home » Server Options » Streams & AQ » Change data capture and alter table add columns

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Change data capture and alter table add columns [message #167511]

Thu, 13 April 2006 07:48

cutieraj
Messages: 1
Registered: April 2006

Junior Member

We have a table A in the database A. We are capturing any changes on this table with oracle 10g r2 change data capture. We have a subscriber view defined. How does adding a column to this table A affect my change capture. I want the cdc view to relect the new column added and still show all the change records since my last extend_window call (which was before I added the column). Is that possible? PLEASE HELP

Report message to a moderator