[Oracle Target] When in Unlimited LOB mode, replication from SQL Database's NVARCHAR(MAX) type to Oracle's CLOB type fails with ORA-24806

Ask a Question

Hello support team

[Environment]

Source : Azure SQL Database

Target : Oracle 19c

[Situation]

- When in Unlimited LOB mode, replication from SQL Database's NVARCHAR(MAX) type to Oracle's CLOB type fails with ORA-24806.

- In both Full Load and Change Processing, when ORA-24806 occur , retries continue repeatedly.

- In Limited LOB mode, ORA-24806 does not occur in either FullLoad , Batch optimized apply , Transactional Apply.

- Changing the Oracle data type to NCLOB from CLOB prevents ORA-24806.

- Changing the Output Type of the column to CLOB in Table Settings > Transform does not prevent ORA-24806.

[Question]

Is there a workaround to prevent ORA-24806 from occurring while keeping Oracle data type CLOB?

Best Regards

Nakagawa

0 Replies