CDC on Oracle requiring primary keys
Posted: Mon Nov 08, 2004 3:17 am
Hi All,
can't find a CDC forum here....so I guess this is the 'next best one' to put this question on?? Sorry if it's not...
We have installed and tested Change Data Capture. We are doing an Oracle Apps DW.
One thing we found, which is confirmed in the documentation, is that CDC 'requires' the oracle source table to have a primary key defined. However, Oracle Apps has no primary keys defined on any tables, only unique constraints.
It will not be possible to put primary keys onto the 100 or so tables we are taking out of oracle apps.
We are guessing there must be some 'work around' so that having a primary key is not 'required'. (We can't think of any good reason that it would be required.)
Anyone got any advice/guidance you can give us on how to get CDC to work on ORA Apps where there are not primary keys?
Much appreciation in advance..
can't find a CDC forum here....so I guess this is the 'next best one' to put this question on?? Sorry if it's not...
We have installed and tested Change Data Capture. We are doing an Oracle Apps DW.
One thing we found, which is confirmed in the documentation, is that CDC 'requires' the oracle source table to have a primary key defined. However, Oracle Apps has no primary keys defined on any tables, only unique constraints.
It will not be possible to put primary keys onto the 100 or so tables we are taking out of oracle apps.
We are guessing there must be some 'work around' so that having a primary key is not 'required'. (We can't think of any good reason that it would be required.)
Anyone got any advice/guidance you can give us on how to get CDC to work on ORA Apps where there are not primary keys?
Much appreciation in advance..