Supplimental log problem

[Aagii B]

Hi, I have a 1 question. 

Can i add supplemental log data like "alter table Schema_name.Table_name add supplemental log data(all) columns;" this way instead of whole db level like "alter database add supplemental log data;" ?

When i use "alter table Schema_name.Table_name add supplemental log data(all) columns;" it like that way, it gives me

Mining session stopped due to error. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:265)

io.debezium.DebeziumException: Supplemental logging not properly configured. Use: ALTER DATABASE ADD SUPPLEMENTAL LOG DATA

[Chris Cranford]

Hi -

You actually need both set in your database; however understanding the subtle differences is important. 

The "LOG DATA (ALL) COLUMNS" is mandatory for tables, this guarantees that Oracle records changes for all columns regardless if you perform an insert, update, delete, and regardless if the column changed in the change vectors of the redo entry.  The latter statement does not add full supplemental logging, but instead adds the minimal required for LogMiner to function.  This is why both are necessary for Debezium.

Thanks,
Chris

io.debezium.DebeziumException: Supplemental logging not properly configured. Use: ALTER DATABASE ADD SUPPLEMENTAL LOG DATA --
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/12c56ead-fa68-44c9-94e8-37586d7910a2n%40googlegroups.com.