Home » Server Options » Streams & AQ » Change data capture and alter table add columns
Change data capture and alter table add columns [message #167511] Thu, 13 April 2006 07:48 Go to next message
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

Re: Change data capture and alter table add columns [message #168795 is a reply to message #167511] Sat, 22 April 2006 19:58 Go to previous message
markmal
Messages: 113
Registered: April 2006
Location: Toronto, Canada
Senior Member
It is possible.

Report message to a moderator

Previous Topic: ORA-12638: Credential retrieval failed
Next Topic: Streams Paused for Flow Control
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 04 12:47:36 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.