Prepare the Oracle Data Source

Prepare the Oracle Data Source

Enable PK/UK supplemental logging

Ensure PK/UK supplemental logging is enabled on the Oracle database. If you see the error "minimal supplemental logging should be enabled" then check the status of the supplemental_log_data on the Oracle database and enable using the following SQL query:

SQL> select supplemental_log_data_min from v$database;

SUPPLEME

--------

NO

SQL> alter database add supplemental log data;

Database altered.

Know the Supported Data Types

SharePlex Connector for Hadoop supports the following data types:

TIP: Disable the SharePlex for Oracle parameter SP_OPX_TRIM_TRAILING_ZEROS to avoid data inconsistency in SharePlex Connector for Hadoop. This is especially relevant to the INTERVAL DAY TO SECOND Oracle data type.