Capture from Oracle using LogMiner

In this capture method (=LOGMINER), Fivetran Local Data Processing reads transaction log records using Oracle's logminer interface (dbms_logmnr package). This capture method reads change data over an SQL connection and does not require the High-Volume Agent to be installed on the source database machine. However, this capture method is slower than the method and exposes additional load on the source database.

Grants for LogMiner

The Local Data Processing database User must have the privileges mentioned in section and additionally the following privileges for capturing from Oracle using LogMiner interface:

grant execute on sys.dbms_logmnr to username;

grant select any transaction to username;

grant execute_catalog_role to username;

/* The following grant is required for Oracle 12.1 and later */

grant logmining to username;
content_copy

Limitations of LogMiner Capture Method

• Only Oracle version 11.2.0.3 and above are supported for capturing changes from LogMiner.
• Capture of truncate statements is not supported.
• Capture from XML Data Type columns is not supported.
• Updates that only change LOB columns are not supported.
• Index Organized Tables (IOT) with an overflow segment is not supported.
• Capturing DDL (using action ) changes such as add table as... , drop table... and alter table... including partition operations are not supported.

See Also