Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Remving CDC objects from source database

PeakIndicators_AlastairApr 27 2011 — edited May 10 2011

Hi,
I have a simple test area with two databases. One db is my source, the other my target. I have got CDC working fine and will be deploying to our Dev environment in anger shortly.
Im using JKM Oracle 10G Consistent (LOGMINER).

When I drop the journal, I see all the J$views get removed - Fine.
However the following tables still exist in my source 'work' schema :
SNP_CDC_OBJECTS,
SNP_CDC_SET,
SNP_CDC_SET_TABLE,
SNP_CDC_SUBS

Can someone shed any light as to why ODI doesnt clean these tables up when I drop the journal ?
I would understand if these where database objects but looking at the SNP* prefix, ODI was the only application ever going to intereact with these tables right?
I've no issue manually removing them, would like to understand if there is any reason I should keep them, they get created when I start the journal, at least in autoconfig mode = yes.

Thanks in advance,
Alastair

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 7 2011

Added on Apr 27 2011

#business-intelligence-applications, #data-integrator, #system-management-and-integration

3 comments

647 views