--- title: "Oracle" slug: "oracle-overview-replicate-cloud" updated: 2026-07-23T14:27:52Z published: 2026-07-23T14:27:52Z canonical: "skthelp.syniti.com/oracle-overview-replicate-cloud" stale: true --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # Oracle # **Overview** Replicate Preview enables efficient data movement between Oracle databases and other supported systems, allowing Oracle to be configured as both a source and target endpoint. Users can quickly define replication pipelines by selecting source objects and configuring target destinations, enabling reliable data replication with minimal setup and operational overhead. The platform simplifies pipeline creation while ensuring consistent and scalable data delivery across Oracle environments. > [!NOTE] > Note > > Oracle is currently supported as both a **source and target endpoint** in Replicate Preview, limited to **Snapshot (full load) replication mode**, with Change Data Capture (CDC) and streaming replication not yet supported. ### Supported Versions Currently, the following Oracle versions are supported: Oracle 9i, 10g R2, 19c, 21c, and 23ai ## User Permissions #### Using Oracle as source connection When setting up replications that use Oracle as a source database, you need to be sure that the user ID used for making connections to the database has sufficient privileges to complete all the operations required for Replicate Preview to perform a replication. The following user permissions are required when using Oracle as a Source in Snapshot mode: - **AUTHORITY TO CONNECT TO DATABASE**: This should already be granted when the user is created. - **AUTHORITY TO SELECT TABLES**: Replicate Preview runs a SELECT statement to identify records to replicate. Therefore, the user ID used to make a connection must have adequate authority to run a SELECT statement for tables involved in replication. The command is not needed if the user is the owner of the table (i.e., created the table.) ```plaintext grant create session to replicate_user; or grant connect to replicate_user; grant select on SYS.ALL_USERS to replicate_user; grant select on SYS.ALL_TABLES to replicate_user; grant select on SYS.ALL_TAB_COMMENTS to replicate_user; grant select on SYS.ALL_OBJECTS to replicate_user; grant select on SYS.ALL_VIEWS to replicate_user; grant select on SYS.ALL_TAB_COLUMNS to replicate_user; grant select on SYS.ALL_COL_COMMENTS to replicate_user; grant select on SYS.ALL_CONSTRAINTS to replicate_user; grant select on SYS.ALL_CONS_COLUMNS to replicate_user; grant select on SYS.ALL_IND_COLUMNS to replicate_user; grant select on SYS.ALL_INDEXES grant select on SYS.USER_CONSTRAINTS to replicate_user; grant select on SYS.USER_CONS_COLUMNS to replicate_user; grant select on to replicate_user; ``` #### Using Oracle as a target connection When setting up replications that use Oracle as a source database, you need to be sure that the user ID used for making connections to the database has sufficient privileges to complete all the operations required for Replicate Preview to perform a replication. The following user permissions are required when using Oracle as a Source in Refresh (Snapshot) mode: - **AUTHORITY TO CONNECT TO DATABASE**: This should already be granted when the user is created. - **AUTHORITY TO SELECT TABLES**: Replicate Preview runs a SELECT statement to identify records to replicate. Therefore, the user ID used to make a connection must have adequate authority to run a SELECT statement for tables involved in replication. The command is not needed if the user is the owner of the table (i.e., created the table.) - **AUTHORITY TO UPDATE TABLES, CREATE TABLES**: To create a target table, Replicate Preview requires the permissions below. You first need to grant a quota on the tablespace in which you want to create a table or index. You can either grant unlimited tablespace to the user: ```plaintext grant unlimited tablespace to ; ``` # **Connection Considerations** If you do not have a connection configured, refer to [Connecting to Oracle](/v1/docs/connecting-to-oracle) for step-by-step instructions: When configuring and using a connection to Oracle, consider the following: | Configuration | Details | | --- | --- | | Connection Properties and Pooling | Review connection settings such as timeout values, connection lifetime, and pooling behavior. These parameters can impact performance and resource utilization. | | Network Connectivity and Listener Access | Ensure that the Oracle host and listener port (default: 1521) are reachable. Validate that firewalls, VPNs, or cloud network configurations are not blocking access. | | Replication Mode Awareness | Replicate Preview supports Snapshot (full load) mode only. Incremental replication methods (such as CDC or LogMiner-based extraction) are not available in the current release. | | Large Table and Performance Considerations | For large datasets, consider database performance factors such as indexing, I/O capacity, and query execution time. Schedule replication jobs appropriately to minimize impact on source systems. | In Replicate Preview, configure your workspace using this system datastore and start replicating data. Refer to [Configure Workspace: Datastores](/v1/docs/configure-workspace-datastores) for more information. ## Related Articles - [Create a Connection](/v1/docs/create-a-connection) - [Configure Workspace: Datastores](/v1/docs/configure-workspace-datastores) - [Connecting to Oracle](/v1/docs/connecting-to-oracle)