Chatta subito con l'assistenza
Chat con il supporto

SharePlex 12.1 - Release Notes

Oracle to Oracle replication

SharePlex supports replication from Oracle to Oracle, according to the details below.

Supported target operating systems

For information regarding supported source and target operating systems with specific database versions, see the Compatibility Matrix for Supported Operating Systems and Target Platforms section. To view compatibility across operating systems for remote replication, see Compatibility Across Operating Systems (Remote Collection and Posting).

Supported target versions

SharePlex supports the Standard and Enterprise Editions of Oracle 12cR1, 12cR2, 18c, 19c, 21c, and 23ai*.

Notes:
  • Unless specified, Oracle, RAC, and ASM are supported for the same versions.
  • In addition to the supported operating systems for Oracle and the supported cloud platforms for Oracle, the Oracle versions listed above are also supported when running on an on-premises Oracle Exadata Database Machine. Any issues reported on an on-premises Oracle Exadata Database Machine will be tested against Oracle Exadata Cloud Service for reproduction purposes.
  • Amazon RDS for Oracle 12cR1 (supported 12cR1 versions are 12.1.0.2.v7 or later) and 19c. Support for Oracle features on Amazon RDS is limited to the default option groups: default:oracle-ee-12-1, default:oracle-ee-19, and default:oracle-se2-19.
  • On Windows Server, Oracle 19c versions below 19.6 have an Oracle bug (29865658) that causes the SharePlex ora_setup, Reader, and Poster processes to get stuck. This bug is fixed in version 19.6 and later.To avoid this issue with SharePlex, either upgrade the Oracle 19c database to version 19.6 or higher. Users need to contact Oracle to obtain a patch for bug 29865658 or set the CLIENT_STATISTICS_LEVEL database parameter to 'OFF'.

*See Conditions of Support for Oracle 23ai for details on support conditions.

Supported target cloud platforms

Oracle Cloud Infrastructure

  • Oracle Exadata Cloud Service (ExaCS)1
  • Oracle Exadata Cloud@Customer (ExaCC)1
  • Oracle Database Cloud Service (DBCS)2

    • Enterprise Standard Edition

    • Enterprise Edition High Performance

    • Enterprise Edition Extreme Performance

  • Oracle Compute (IaaS) Virtual Machines and Bare Metal

Amazon Web Services

  • Amazon RDS for Oracle 3
  • Amazon EC2 (IaaS) Virtual Machine

Microsoft Azure

Azure Virtual Machine (IaaS)

Conditions of support

  1. Oracle Exadata: Issues on Oracle Exadata will be tested against Oracle Exadata Cloud Service for reproduction purposes.

  2. Oracle Database Cloud Service (DBCS): SharePlex only supports Transparent Data Encryption (TDE) feature on DBCS EE-HP, DBCS EE-EP, and ExaCS/CC.

  3. Amazon RDS for Oracle: Please see Supported Oracle Source and Target Versions for additional clarification on version compatibility.

Supported data types

SharePlex supports the following Oracle data types for replication to Oracle targets. See the Conditions of support for additional information.

  • ANYDATA 1
  • B-FILE
  • BINARY DOUBLE 7
  • BINARY FLOAT 7
  • BLOB 2
  • CHAR
  • CLOB 2
  • DATE
  • INTERVAL
  • LONG RAW2
  • LONG 2
  • NCHAR
  • NCLOB 3
  • NUMBER
  • NVARCHAR2 8
  • RAW 8
  • ROWID
  • SDO_GEOMETRY
  • TIMESTAMP
  • TIMESTAMP WITH LOCAL TIME ZONE
  • TIMESTAMP WITH TIME ZONE
  • UDT (User Defined Type)5
  • UROWID
  • VARCHAR
  • VARCHAR2 8
  • VARRAY collectors
  • XMLTYPE 4

Note: SharePlex supports columns that are defined as INVISIBLE.

Conditions of support

1. ANYDATA

  • Replication of ANYDATA is supported, except when it contains a UDT or the storage is defined as SecureFile LOB with compression. SecureFile LOB without compression is supported. Only the following data types within ANYDATA are supported by SharePlex:

    • CHAR
    • DATE
    • NUMBER
    • RAW
    • VARCHAR
    • VARCHAR2
    • TIMESTAMP
  • A data type within an ANYDATA type must be in-row (inside the column data). Oracle encapsulates the ANYDATA type as an in-row secure file LOB. If the encapsulated data is longer than the length allowed for an in-row LOB, that data appears as out-of-row LOB data. SharePlex assumes that the encapsulated data always appears as in-row LOB.

2. LONG and LOB (BLOB, CLOB)

  • Any table that contains a LOB or LONG should have a primary key or unique key defined on it. If a table does not have a key, SharePlex builds its own key from all of the columns except LONGs or LOBs. If a LOB or LONG is the only difference between two rows that otherwise satisfy the Post WHERE clause, SharePlex cannot guarantee that the correct row will be updated.

  • SharePlex supports SecureFiles LOBs as follows:

    • Logging must be enabled.
    • SharePlex supports uncompressed SecureFiles LOBS and SecureFiles LOBS with high or medium compression (compressed with ZLIB or ZSTD compression libraries)
    • SecureFiles LOBS are not supported when the storage specification includes encryption and/or deduplication.
  • SharePlex does not support LONG and LONG_RAW data types in a configuration where transformation or conflict resolution are performed.

3. NCLOB

NCLOBs are not supported by Compare/Repair if the source and target have different character sets.

4. XMLTYPE

SharePlex supports the replication of XMLTYPE stored as CLOB and BINARY. SharePlex does not support XMLTYPE stored as OBJECT RELATIONAL or TRANSPORTABLE BINARY. Additionally, the following applies:

  • XMLTYPE stored as BINARY is not supported when the storage is defined as SecureFile LOB with compression. SecureFile LOB without compression is supported.

  • Binary XMLTypes are not supported by Compare/Repair when the source and target character sets are different and require character set conversion.
  • Compare/Repair does not support comparison of XMLTYPE when the source and target have different storage clauses. Compare/Repair only supports compare/repair when source and target are both stored as BINARY or both are stored as CLOB.

5. Parquet Type

SharePlex supports data replication from an Oracle source in Parquet format on Linux.

5. User-defined types

SharePlex does not support abstract data types and VARRAYs in a configuration where the SharePlex conflict resolution feature is performed.

NOTE: SharePlex replicates tables with the UDT fields in the base type ONLY. In case of columns containing multiple subtypes, replication is applicable only for base type fields.

6. General

If the precision or size of the target data type is not large enough for the data being replicated, the data may be truncated or rounded by the database when applied.

7. BINARY DOUBLE and BINARY FLOAT

The BINARY DOUBLE and the BINARY FLOAT data types are not supported for the copy command.

8. Extended Data Types

  • Extended Data Types are not supported for the copy command.
  • Extended Data Types are not supported on a key column. The keys that do not support the Extended Data Types include:
    • Primary key on the Oracle table
    • Unique key on the Oracle table
  • Horizontal partitioning is not supported by tables containing the Extended Data Type columns.
  • SharePlex does not replicate data with Extended Data Type when target type is JMS Message Queues, File output (XML, JSON, SQL, Parquet ), Event Hubs, or Kafka.

Supported operations and objects for DDL replication

SharePlex provides default and optional DDL support.

Note: ALTER TABLE to ADD COLUMN and ALTER TABLE to DROP COLUMN are supported on Basic, Advanced Row (OLTP) Compression, and HCC compressed Oracle objects for replication to all Oracle and open targets.

SharePlex does not support:

  • ANALYZE TABLE and ANALYZE INDEX
  • DDL to ALTER TABLE ADD OVERFLOW to an IOT in replication
  • DDL operations issued by the SharePlex database user
  • DDL to ALTER INDEX to an IOT in replication

  • During DDL replication, data containing the ALTER statement related to Oracle extended statistics—'Virtual by User'— is not supported. Oracle also does not recommend to use the extended stastistics 'Virtual by User'.

DDL on objects listed in the active configuration file

SharePlex supplies default and optional DDL replication for objects whose names are listed in the configuration file explicitly or by wildcard. See "Conditions of support" following this table for additional information.

For details about the controlling parameter, see the SharePlex Reference Guide.

Supported object Supported DDL Operation

Enabled by default?

Controlling parameter

Table and IOT

(when they exist in the source at the time of configuration activation)

Truncate

Alter to add, drop, modify columns

Alter to add, modify, drop, split, coalesce, move, truncate, exchange partition or subpartition1

Drop Table

Yes

SP_OCT_REPLICATE_DDL=3

Table and IOT

(when they are added to the source after configuration activation)

Create

Create as Select2

Yes

SP_OCT_AUTOADD_ENABLE=1

Table Alter Table Rename Yes SP_OCT_DDL_UPDATE_CONFIG=1
Index

Create

Alter

Drop

Yes

SP_OCT_AUTOADD_ENABLE=1

Materialized View3

Create

Drop

No

SP_OCT_AUTOADD_ENABLE=1 and

SP_OCT_AUTOADD_MVIEW=1 and

SP_SYS_TARGET_COMPATIBILITY=8.6.2 or higher

Sequences4

Create, Drop

No

SP_OCT_AUTOADD_ENABLE=1 and

SP_OCT_AUTOADD_SEQ=1 and

SP_SYS_TARGET_COMPATIBILITY=8.6.3 or higher

Trigger

Create, Drop

No

 SP_OCT_REPLICATE_TRIGGER=1

Synonym

Create, Drop

No

 SP_OCT_REPLICATE_SYNONYM=1
Grant5 Create, Drop

No

 SP_OCT_REPLICATE_GRANT=1
Conditions of support
  1. ALTER TABLE has the following conditions of support:
    • ALTER TABLE DDL that involves multiple tables, such as EXCHANGE PARTITION between tables, requires all tables involved to be in replication.
    • Default DDL support for ALTER TABLE on partitions/subpartitions applies to user-named interval partitions/subpartitions. For system-named (system generated) interval partitions/subpartitions, SharePlex supports only ALTER TABLE to DROP and TRUNCATE the system-named partitions. To enable support for DROP and TRUNCATE of system-named partitions, set the SP_OCT_TRUNC_PARTITION_BY_ID parameter to 1, and ensure that both source and target are updated to SharePlex version 8.6.4 or later. NOTE: This requirement has changed from previous SharePlex releases in that the parameter must now be set regardless of the Oracle version, including for Oracle 12.2 and later.
    • SharePlex does not support TRUNCATE of a system-generated sub-partition if the sub-partition is empty. In such cases, Post stops with error SP-OPO01002. To configure Post to ignore this error, stop Post, set the SP_OPO_CONT_ON_ERR parameter to 1, and add error number SP-OPO01002 to the top of the oramsglist file. See the SharePlex Reference Guide for more information about this parameter.
  1. For CREATE TABLE AS SELECT, SharePlex supports the following data types: LONG, DATE, RAW, LONG RAW, ROWID, LONG VARCHAR, CHAR, CLOB, BLOB, CFILE, BFILE, TIMESTAMP, INTERVAL YEAR TO MONTH, INTERVAL DAY TO SECOND, VARCHAR2, NUMBER, and ANYDATA.

  2. For CREATE MATERIALIZED VIEW the following applies:

    • SharePlex supports the following data types for CREATE MATERIALIZED VIEW: LONG, DATE, RAW, LONG RAW, ROWID, UROWID, LONG VARCHAR, CHAR, CLOB, BLOB, CFILE, BFILE, TIMESTAMP, INTERVAL YEAR TO MONTH, INTERVAL DAY TO SECOND, VARCHAR2, NUMBER, and ANYDATA. SharePlex does not support ALTER MATERIALIZE VIEW.
    • SharePlex converts a CREATE MATERIALIZED VIEW to a CREATE TABLE, applies the CREATE TABLE to the target, and then replicates the DML that populates the view. SharePlex does not replicate materialized views to materialized views.

  3. To replicate sequences, the supplemental logging of primary and unique keys must be enabled at the database level, or you must enable supplemental logging for primary keys on the sys.seq$ table.

  4. Amazon RDS restricts DBA users from issuing the GRANT command. Because SharePlex runs as the DBA user, SharePlex cannot replicate GRANT to or from an RDS database.

DDL on objects not listed in the active configuration file

SharePlex provides expanded DDL support for Oracle objects that are not listed in the configuration file. SharePlex replicates the DDL statements for these objects, but does not maintain synchronization of the objects through DML replication. Expanded DDL replication is optional and is enabled with the following parameter setting:

SP_OCT_REPLICATE_ALL_DDL=1

Note: Expanded DDL replication supports not only tables and sequences but also a wide range of other objects such as procedures, functions, users, and views, which are not part of replication. Some of these objects may have underlying objects that are in replication. In those cases, Expanded DDL replication applies to the underlying objects in replication, as well as to the object that is not in replication.

See "Table Notes" following this table for additional information.

Supported object Supported Operation
Table and IOT Create table
Create table as select
Alter table add column
Alter table drop column
Drop table
Truncate
Comment on table
Comment on columns
Associate Statistics
Disassociate Statistics
Cluster Create cluster
Crop cluster
Sequence Create
Drop
Alter

Partition/ Subpartition

 Add
Split
Merge
Drop
Modify
Coalesce
Exchange
Move
Truncate
Rename
Set
Index Create
Alter
Drop
View Create
Alter
Drop
Comment on view
Synonym Create
Drop
Directory1 Create
Drop
User-defined type Create type
Alter type
Drop type
Create type body
Drop type body
Stored procedure Create
Alter
Drop
Stored function Create
Alter
Drop
Package Create package
Create package body
Alter package
Alter package body
Drop package
Drop package body
User Create user
Alter user
Drop user
Grant1
Revoke
Role Create role
Alter role
Drop role
Grant1
Revoke
Table Notes:

Amazon RDS restricts DBA users from issuing certain commands on an Amazon RDS database instance. Because SharePlex runs as the DBA user, SharePlex cannot replicate the following commands to or from an RDS database:

  • CREATE or DROP DIRECTORY
  • GRANT

Supported operations and objects for DML replication

SharePlex supports DML operations on tables and sequences, with some conditions. DML can be replicated from an Oracle source to an Oracle target. For additional information, see Supported Operations and Objects for DML Replication.

Oracle to PostgreSQL replication

SharePlex supports replication from Oracle to PostgreSQL, according to the details below.

Supported target operating systems

For information regarding supported source and target operating systems with specific database versions, see the Compatibility Matrix for Supported Operating Systems and Target Platforms section. To view compatibility across operating systems for remote replication, see Compatibility Across Operating Systems (Remote Collection and Posting).

Supported target versions and ODBC requirements

  • PostgreSQL 13.4, 13.6, 14.1, 15.x, 16, and 17

  • Enterprise Database (EDB) 15.x, 16

  • Fujitsu Enterprise PostgreSQL 15 SP2, 16, and 17

  • AlloyDB Omni 15.5.x

ODBC driver requirement:

ODBC drivers for Community Edition: postgresql13-odbc-13.02.0000, postgresql14-odbc-13.02.0000,postgresql15-odbc-16.00.0000, and postgresql16-odbc-16.00.0000

ODBC drivers for Enterprise Edition (EDB): edb-odbc-13.02.0000, edb-odbc-16.00.0000.01

Supported target cloud databases and platforms

Oracle Cloud Infrastructure

Oracle Compute (IaaS) Virtual Machines and Bare Metal

Amazon Web Services

  • Amazon RDS for PostgreSQL
  • Amazon Aurora
  • Amazon EC2 (IaaS) Virtual Machine

Microsoft Azure

  • Azure Virtual Machine (IaaS)
  • Azure DBaaS

Google Cloud Platform

  • Cloud SQL for PostgreSQL

  • AlloyDB for PostgreSQL

Supported data types

SharePlex supports the following data types for replication from Oracle to PostgreSQL:

Oracle PostgreSQL
BINARY_DOUBLE DOUBLE PRECISION
BINARY_FLOAT REAL
CHAR (n) CHAR (n)
CHAR (n CHAR) CHAR (n)
CLOB TEXT
DATE DATE
DATE TIMESTAMP (0)
LONG TEXT
NCHAR (n) CHAR (n)
NCLOB TEXT
NUMBER

NUMERIC / DOUBLE PRECISION

NUMBER(p) NUMERIC (p)
NUMBER (p,s) NUMERIC (p,s)
NVARCHAR2 (n) VARCHAR (n)
RAW BYTEA
TIMESTAMP (7:9) TIMESTAMP (6)
TIMESTAMP (p) TIMESTAMP (p)
TIMESTAMP (7:9) WITH TIME ZONE TIMESTAMP (6) WITH TIME ZONE
TIMESTAMP (p) WITH TIME ZONE TIMESTAMP (p) WITH TIME ZONE
TIMESTAMP (7:9) WITH LOCAL TIME ZONE TIMESTAMP (6)
TIMESTAMP (p) WITH LOCAL TIME ZONE TIMESTAMP (p)
VARCHAR2 (n) VARCHAR (n)
VARCHAR2 (n CHAR) VARCHAR (n)
BLOB BYTEA

Condition of support: Inserting the chr(0) (null) character is not supported during data replication from Oracle to PostgreSQL.

Supported operations and objects for DML replication

SharePlex supports DML operations on tables and sequences, with some conditions. DML can be replicated from an Oracle source to a PostgreSQL target. For additional information, see Supported Operations and Objects for DML Replication.

Supported operations and objects for DDL replication

SharePlex supports DDL operations on tables and sequences, with some conditions. DDL can be replicated from an Oracle source to a PostgreSQL target. For additional information, see Oracle to open target DDL support.

Oracle to Snowflake replication

SharePlex supports replication from Oracle to Snowflake, according to the details below.

Supported operating systems

For information regarding supported source and target operating systems with specific database versions, see the Compatibility Matrix for Supported Operating Systems and Target Platforms section. To view compatibility across operating systems for remote replication, see Compatibility Across Operating Systems (Remote Collection and Posting).

Supported target versions and ODBC requirements

Snowflake 8.38.2

ODBC driver requirement: from Snowflake 3.1.4 to 3.8

Limitation: The Snowflake 3.3 to 3.5 drivers are not supported on the Windows platform. For additional details, see the description of issue SPSQL-8415 under the Known Issues in this Release section.

Supported target cloud platforms

  • Microsoft Azure

  • Amazon Web Services

Supported data types

SharePlex supports the following data types for replication from Oracle to Snowflake:

Oracle Snowflake
CLOB TEXT
NUMBER INT, INTEGER, NUMBER
CHAR(n) VARCHAR(n)
CLOB VARCHAR(n)
NCHAR CHAR(n)
VARCHAR2(n) VARCHAR(n)
CLOB VARCHAR(n)
NCLOB TEXT
CLOB VARCHAR(n)
LONG TEXT
BLOB BINARY, VARBINARY
RAW(n) VARBINARY
LONGRAW VARBINARY
BINARY_FLOAT REAL
NUMBER SMALLINT
NUMBER BIGINT
NUMBER NUMERIC, DECIMAL
DATE DATE
BINARY_DOUBLE DOUBLE PRECISION
TIMESTAMP TIMESTAMP
TIMESTAMP_TZ TIMESTAMP_TZ

Note: It is anticipated that the Snowflake DB's default "HEX" format for binary type will be maintained for Oracle binary to Snowflake binary data type replication. Since source Oracle DB binary data is stored only in "HEX" format, Shareplex does not guarantee data integrity for any other format.

Conditions of support

  • Char(n) data type - In Oracle, Char(n) is a fixed-size data type. If you insert char data with a length less than "n" into the "Char(n)" column, the remaining slots (n - length) are padded with space to occupy the complete "n" memory positions. Snowflake uses  VARCHAR(n) for char storage since Snowflake lacks a comparable fixed-length character data type and only saves char data up to its length. Live replication will ensure that char column data is correctly copied. However, if users are manually inserting data into Snowflake for the equivalent of a Char(n) Oracle column, then the user will need to handle padding as well to occupy the full "n" length so that data will be in sync in both the source and target DB.

  • Binary & Text data types - Snowflake Binary & Text data types have size limitation of 8 MB, so Oracle’s advance Data type replication will be restricted to max 8 MB size limit of equivalent counterpart. Refer table below.

Oracle Data type Max Size Snowflake Data type Max Size
LONG 2 GB TEXT 8 MB of unicode chars
CLOB 4 GB TEXT 8 MB of unicode chars
LONGRAW 2 GB BINARY or VARBINARY 8 MB
BLOB 4 GB BINARY or VARBINARY 8 MB

See Conditions of support for the additional conditions of support for the above-mentioned supported data types.

Supported operations and objects for DML replication

SharePlex supports DML operations on tables, with some conditions. DML can be replicated from an Oracle source to a Snowflake target.

Tables

SharePlex supports the following DML operations on tables when replicating data from an Oracle source to the Snowflake target:

  • Singular and bulk operation - Insert with key(s)/ non key(s)

  • Singular and bulk operation - Update with key(s)/ non key(s)

  • Singular and bulk operation - Delete with key(s)/ non key(s)

Limitations:

The following DML operations related limitations are observed while replicating data from Oracle to Snowflake:

  • Slowness while performing DML operations

    • Single Insert: Frequent commits and rollbacks can cause slowness in replication.

    • Batch Inserts: Insert with advance data types [target Snowflake data types: TEXT and BINARY] can cause significant slowness in replication for data with plain text or binary JSON and XML.

    • Single Update and Delete : Frequent commits and rollbacks can cause slowness.

For additional information, see Supported Operations and Objects for DML Replication.

Supported operations and objects for DDL replication

SharePlex does not support DDL operations and objects when replicating data from an Oracle source to a Snowflake target.

Oracle to SQL Server replication

SharePlex supports replication from Oracle to SQL Server, according to the details below.

Supported target operating systems

For information regarding supported source and target operating systems with specific database versions, see the Compatibility Matrix for Supported Operating Systems and Target Platforms section. To view compatibility across operating systems for remote replication, see Compatibility Across Operating Systems (Remote Collection and Posting).

Supported target versions and ODBC requirements

SQL Server 2016, 2017, 2019, and 2022

ODBC driver requirement: ODBC 17.10.1.1-1 and 18.3.2.1-1

Supported target cloud platforms and databases

Amazon Web Services

Amazon EC2 (IaaS) Virtual Machine

Microsoft Azure

  • Azure Virtual Machine (IaaS)
  • Azure SQL Database
  • Azure SQL Managed Instance

Supported data types

SharePlex supports the following data types for replication from Oracle to SQL Server:

Oracle SQL Server
ANYDATA VARIENT
BINARY_DOUBLE FLOAT (53)
BINARY_FLOAT FLOAT (24)
BLOB VARBINARY (MAX)
CHAR (n) CHAR (n)
CHAR (n CHAR) CHAR (n)
CLOB VARCHAR (MAX)
DATE DATETIME2 (7)
LONG VARCHAR (MAX)
LONGRAW VARBINARY (MAX)
NCHAR (n) NCHAR (n)
NCLOB NVARCHAR (MAX)
NUMBER FLOAT (53)
NUMBER (p,0:) NUMERIC (p,s)
NUMBER (p,0:)* DECIMAL
NUMBER (p,s) FLOAT (53)
NVARCHAR2 (n) NVARCHAR (n)
RAW (n) VARBINARY (n)
TIMESTAMP (8:9) DATETIME2 (7)
TIMESTAMP (p) DATETIME2 (p)
TIMESTAMP (8:9) WITH TIME ZONE DATETIMEOFFSET (7)
TIMESTAMP (p) WITH TIME ZONE DATETIMEOFFSET (p)
VARCHAR2 (n) VARCHAR (n)
VARCHAR2 (n CHAR) VARCHAR (n)

Conditions of support:

NUMBER (P, 0) - DECIMAL: If we add a new column with the Number data type in the Oracle source, the new column will be replicated with the Numeric data type to the SQL Server target.

See Conditions of support for the additional conditions for the above-mentioned supported data types.

Supported operations and objects for DML replication

SharePlex supports DML operations on tables and sequences, with some conditions. DML can be replicated from an Oracle source to an SQL Server target. For additional information, see Supported Operations and Objects for DML Replication.

Supported operations and objects for DDL replication

SharePlex supports DDL operations on tables and sequences, with some conditions. DDL can be replicated from an Oracle source to an SQL Server target. For additional information, see Oracle to open target DDL support.

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione