Skip to main content

Documentation Index

Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt

Use this file to discover all available pages before exploring further.

NameOracle
DescriptionOracle Database is a multi-model database management system produced by Oracle Corporation
Linkhttps://www.oracle.com/database/
TypeLogMiner CDC
Supported ReplicationInitial Sync Continuous Sync
Authentication TypePassword Authentication

​
Supported Versions

  • Oracle Database 11g Release 2 and above
  • Oracle 12c, 18c, 19c, 21c

​
Variants

​
Required Privileges

NameDescriptionEnforced?Reference
EXECUTE ON DBMS_LOGMNRExecute LogMiner package for reading redo logs✅Oracle Docs
EXECUTE ON DBMS_LOGMNR_DExecute LogMiner dictionary package✅Oracle Docs
SELECT ON V_$LOGQuery redo log information✅
SELECT ON V_$LOGFILEQuery redo log file locations✅
SELECT ON V_$LOGMNR_CONTENTSQuery LogMiner results✅
SELECT ON V_$LOGMNR_LOGSQuery LogMiner registered logs✅
SELECT ON V_$ARCHIVED_LOGQuery archived redo logs✅
SELECT ON V_$DATABASEQuery database information✅
SELECT ON V_$INSTANCEQuery instance information✅
SELECT ON DBA_OBJECTSQuery database objects metadata✅
SELECT ON DBA_TABLESQuery table metadata✅
SELECT ON DBA_TAB_COLUMNSQuery column metadata✅
SELECT ON DBA_CONSTRAINTSQuery constraint metadata✅
SELECT ON DBA_CONS_COLUMNSQuery constraint column metadata✅
SELECT ON DBA_LOG_GROUPSQuery supplemental log groups✅
SELECT ON DBA_LOG_GROUP_COLUMNSQuery supplemental log group columns✅
SELECT ANY TABLESelect from source tables✅
LOGMININGOracle 12c+ privilege for LogMiner access✅

​
Required Configurations

NameDescriptionRecommended ValueEnforced?Reference
ARCHIVELOG ModeDatabase must be in ARCHIVELOG mode to enable redo log archiving for LogMinerEnabled✅Oracle Docs
Supplemental Logging (Database)Minimal supplemental logging at database levelALTER DATABASE ADD SUPPLEMENTAL LOG DATA✅Oracle Docs
Supplemental Logging (Primary Key)Primary key supplemental logging for row identificationALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS✅
Supplemental Logging (Table)Table-level supplemental logging for each synced tableALTER TABLE schema.table ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS✅
Archive Log Retention (RDS)Hours to retain archived redo logs24 hours minimumAWS Docs
Notes:
  • LogMiner reads redo logs to capture INSERT, UPDATE, DELETE operations
  • CLOB/BLOB columns are automatically converted to strings/buffers
Last modified on May 12, 2026