> ## 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.

# ELT/CDC: Sources - Oracle CDC

> Configure Oracle CDC as a data source in Integrate.io ELT & CDC. Set up change data capture from Oracle databases for real-time replication.

| **Name**                  | Oracle                                                                                     |
| :------------------------ | :----------------------------------------------------------------------------------------- |
| **Description**           | Oracle Database is a multi-model database management system produced by Oracle Corporation |
| **Link**                  | [https://www.oracle.com/database/](https://www.oracle.com/database/)                       |
| **Type**                  | LogMiner CDC                                                                               |
| **Supported Replication** | Initial Sync   Continuous Sync                                                             |
| **Authentication Type**   | Password Authentication                                                                    |

### Supported Versions

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

### Variants

* [AWS RDS Oracle](/cdc/aws-rds-oracle)
* [Self Hosted](/cdc/oracle-cdc-self-hosted)

### Required Privileges

| Name                               | Description                                    | Enforced? | Reference                                                                                             |
| :--------------------------------- | :--------------------------------------------- | :-------- | :---------------------------------------------------------------------------------------------------- |
| EXECUTE ON DBMS\_LOGMNR            | Execute LogMiner package for reading redo logs | ✅         | [Oracle Docs](https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_LOGMNR.html)   |
| EXECUTE ON DBMS\_LOGMNR\_D         | Execute LogMiner dictionary package            | ✅         | [Oracle Docs](https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_LOGMNR_D.html) |
| SELECT ON V\_\$LOG                 | Query redo log information                     | ✅         |                                                                                                       |
| SELECT ON V\_\$LOGFILE             | Query redo log file locations                  | ✅         |                                                                                                       |
| SELECT ON V\_\$LOGMNR\_CONTENTS    | Query LogMiner results                         | ✅         |                                                                                                       |
| SELECT ON V\_\$LOGMNR\_LOGS        | Query LogMiner registered logs                 | ✅         |                                                                                                       |
| SELECT ON V\_\$ARCHIVED\_LOG       | Query archived redo logs                       | ✅         |                                                                                                       |
| SELECT ON V\_\$DATABASE            | Query database information                     | ✅         |                                                                                                       |
| SELECT ON V\_\$INSTANCE            | Query instance information                     | ✅         |                                                                                                       |
| SELECT ON DBA\_OBJECTS             | Query database objects metadata                | ✅         |                                                                                                       |
| SELECT ON DBA\_TABLES              | Query table metadata                           | ✅         |                                                                                                       |
| SELECT ON DBA\_TAB\_COLUMNS        | Query column metadata                          | ✅         |                                                                                                       |
| SELECT ON DBA\_CONSTRAINTS         | Query constraint metadata                      | ✅         |                                                                                                       |
| SELECT ON DBA\_CONS\_COLUMNS       | Query constraint column metadata               | ✅         |                                                                                                       |
| SELECT ON DBA\_LOG\_GROUPS         | Query supplemental log groups                  | ✅         |                                                                                                       |
| SELECT ON DBA\_LOG\_GROUP\_COLUMNS | Query supplemental log group columns           | ✅         |                                                                                                       |
| SELECT ANY TABLE                   | Select from source tables                      | ✅         |                                                                                                       |
| LOGMINING                          | Oracle 12c+ privilege for LogMiner access      | ✅         |                                                                                                       |

### Required Configurations

| Name                               | Description                                                                   | Recommended Value                                                | Enforced? | Reference                                                                                                                |
| :--------------------------------- | :---------------------------------------------------------------------------- | :--------------------------------------------------------------- | :-------- | :----------------------------------------------------------------------------------------------------------------------- |
| ARCHIVELOG Mode                    | Database must be in ARCHIVELOG mode to enable redo log archiving for LogMiner | Enabled                                                          | ✅         | [Oracle Docs](https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-archived-redo-log-files.html) |
| Supplemental Logging (Database)    | Minimal supplemental logging at database level                                | ALTER DATABASE ADD SUPPLEMENTAL LOG DATA                         | ✅         | [Oracle Docs](https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-logminer-utility.html)          |
| Supplemental Logging (Primary Key) | Primary key supplemental logging for row identification                       | ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS   | ✅         |                                                                                                                          |
| Supplemental Logging (Table)       | Table-level supplemental logging for each synced table                        | ALTER TABLE schema.table ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS | ✅         |                                                                                                                          |
| Archive Log Retention (RDS)        | Hours to retain archived redo logs                                            | 24 hours minimum                                                 |           | [AWS Docs](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.Oracle.CommonDBATasks.Log.html)               |

<Note>
  **Notes**:

  * LogMiner reads redo logs to capture INSERT, UPDATE, DELETE operations
  * CLOB/BLOB columns are automatically converted to strings/buffers
</Note>