--- title: "Create a Refresh Replication from Oracle" slug: "create-a-refresh-replication-from-oracle" updated: 2025-01-10T06:07:15Z published: 2025-01-10T06:07:15Z canonical: "skthelp.syniti.com/create-a-refresh-replication-from-oracle" --- > ## 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. # Create a Refresh Replication from Oracle ## Overview Refresh is a snapshot replication executed once, based on the time setting specified in the [Scheduling](https://skthelp.syniti.com/v1/docs/replication-properties-dialog#scheduler-tab) screen. ### User Permissions 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 Syniti Replicate 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:** Syniti Replicate 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; ``` ### Create a Refresh Replication from Oracle Once the Oracle connection was created in your Management Center, you have to follow the [steps to run a Refresh replication](/v1/docs/steps-for-replicating-a-table-using-refresh-mode). A Refresh replication provides some additional setting that allow you to improve this process, we recommend to read those articles: - [Define a replication scenario](/v1/docs/database-replication-scenarios) - [How to apply filtering (where condition) in your Refresh Replication](https://skthelp.syniti.com/docs/en/expression-generator#using-the-expression-generator-for-defining-a-refresh-filter) - [Create Refresh Partitions for big tables](/v1/docs/using-partitions-for-refresh-replications) - [Use scripts for additional functionalities](/v1/docs/writing-scripts-in-syniti-replicate) - [Execute verifications to validate data discrepancies](/v1/docs/verifier) - [Schedule a Refresh replication execution](/v1/docs/scheduler-dialog) - [Configure an e-mail alert once your replication is complete](/v1/docs/email-error-alerts)