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.
SharePlex Connector for Hadoop supports the following data types:
Oracle Type |
XML Type |
---|---|
CHAR | string |
DATE |
dateTime |
FLOAT |
decimal |
NCHAR |
string |
NUMBER |
decimal |
NVARCHAR2 |
string |
ROWID |
string |
VARCHAR2 |
string |
INTERVAL YEAR TO MONTH |
yearMonthDuration |
INTERVAL DAY TO SECOND |
dayTimeDuration |
TIMESTAMP |
dateTime |
TIMESTAMP WITH TIME ZONE |
dateTimeStamp |
TIMESTAMP WITH LOCAL TIME ZONE |
dateTimeStamp |
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.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 이용 약관 개인정보 보호정책 Cookie Preference Center