table level logging not working in streams
edited Oct 22, 2010 4:02PM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered
HI,
I am trying to run this example http://wedostreams.blogspot.com/2009/01/oracle-streams-101.html on a 11.2.0.2 win64.
I have enabled table level logging with alter table add supplemental log data (all) columns;
after running DBMS_CAPTURE_ADM.CREATE_CAPTURE , it seems the procedure automatically turns on supplemental logging at database level with
alter database add supplemental log data;
If I just ignore the database level logging, then the example works as it should. But If I do alter database drop supplemental log data just after the DBMS_CAPTURE_ADM.CREATE_CAPTURE
statement, it stops working and I get a fatal error(ora 01280) on my capture. I have 150 table with millions of rows. I just want to capture one table and do not want to generate a lot of redo
I am trying to run this example http://wedostreams.blogspot.com/2009/01/oracle-streams-101.html on a 11.2.0.2 win64.
I have enabled table level logging with alter table add supplemental log data (all) columns;
after running DBMS_CAPTURE_ADM.CREATE_CAPTURE , it seems the procedure automatically turns on supplemental logging at database level with
alter database add supplemental log data;
If I just ignore the database level logging, then the example works as it should. But If I do alter database drop supplemental log data just after the DBMS_CAPTURE_ADM.CREATE_CAPTURE
statement, it stops working and I get a fatal error(ora 01280) on my capture. I have 150 table with millions of rows. I just want to capture one table and do not want to generate a lot of redo
0