Oracle as Target

Data Source Solutions DSS supports integrating changes into Oracle database. This section describes the configuration requirements for integrating changes (using Integrate and Refresh) into Oracle location.

For the list of supported Oracle versions, into which DSS can integrate changes, see Integrate changes into location in Capabilities.

DSS uses the following interfaces to write data to Oracle during Refreshing Data or Integrate:

• Oracle native OCI interface, used for continuous Continuous Integrate and Row-wise Refresh.
• Oracle OCI direct-path-load interface, used for Burst Integrate and Bulk Refresh.

Grants for Integrate and Refresh

This section lists the grants required for integrating changes into Oracle.

1. The DSS database User must be allocated a quota on the default tablespace. For this, the DSS database user must be granted the following privilege:

   alter user <em>username</em> quota <em>quotalimit</em> on <em>tablespacename</em>;
   

   Alternatively, unlimited tablespace quota may be granted:

   grant unlimited tablespace to <em>username</em>;
   

2. To Integrate changes or to Refresh data into Oracle database, the DSS database User must be granted <b>create session</b> and <b>create table</b> privileges:

   grant create session to <em>username</em>;
   
   grant create table to <em>username</em>;
   

3. To create target tables using Refresh, the DSS database User must be granted <b>create any index</b>, <b>drop any index</b>, <b>create any table</b>, <b>alter any table</b>, and <b>drop any table</b> privileges:

   grant create, drop any index to <em>username</em>;
   
   grant create, alter, drop any table to <em>username</em>;
   

4. To change tables which are owned by other schemas (using action TableProperties with parameter Schema), the DSS database User must be granted the following <b>select any table</b>, <b>insert any table</b>, <b>update any table</b>, and <b>delete any table</b> privileges:

   grant select, insert, update, delete any table to <em>username</em>;
   

5. To perform Bulk Refresh of tables which are owned by other schemas, the DSS database User must be granted the following <b>alter any table</b>, <b>lock any table</b>, and <b>drop any table</b> privileges :

   grant alter, lock any table to <em>username</em>;
   
   /* Following grant is required for <b>truncate</b> statements */
   
   grant drop any table to <em>username</em>;
   

6. To use action DbSequence with parameter Schema, the DSS database User must be granted <b>create any sequence</b> and <b>drop any sequence</b> privileges:

   grant create, drop any sequence to <em>username</em>;
   

7. To disable/re-enable triggers in target schema, the DSS database User must be granted the <b>create any trigger</b> and <b>alter any trigger</b> privileges:

   grant create, alter any trigger to <em>username</em>;
   

Intermediate Directory

{% partial file="dss6/requirements/source-and-target-requirements/intermediate-directory.template.md" /%}

Intermediate Directory is Local

{% partial file="dss6/requirements/source-and-target-requirements/intermediate-directory-local.template.md" /%}