This content has been marked as final. Show 3 replies
Are there packages that allow you to query useful CDC tables? Useful for what? In what version? For Synchronous, Asynch HotLog, or Asynch AutoLog? Related to publishers or subscribers?
In other words there is no way to answer your question as written.
My recommendation is that you start here:
Otherwise there are some interesting APIs in DBMS_CDC_UTILITY but I suspect it is not what you are looking for:
select object_name from dba_objects where object_type in ('TABLE', 'VIEW') and object_name like 'CDC%' order by 1; select object_name from dba_objects where object_type in ('TABLE', 'VIEW') and object_name like 'DBA%QUEUE%' order by 1;
For CDC Demos go to Morgan's Library
Thank you for the information, and sorry for the confusion, yes, I am looking for the packages that allow me to get some information from those cdc tables(I already have cdc tables with change records in it). what you told me about the DBMS_CDC_UTILITY package is useful, but it is too general(high level) that I can not use.
For the CDC tables I have, there are many changes records over there, I just need some useful records(rows), now it is difficult for me to write plsql to get it directly.
The Oracle DB I am using is 11g, Synchronous, and related to the subscriber, and I have the dw_.._cdc tables already, if there are not so many built in package for me to query the dw_.._cdc tables, what I can do is:
(1) to write complex plsql directly to query these cdc tables
(2)recreate the cdc tables(many original tables combined to one table): to modify the publisher part to make the data(for subscriber) more related to what I want
Im new to the cdc concept, please give me some advise, Thank you.
Simple advice: Start writing SQL because what you are looking for does not exist.