How to fix the Oracle error ORA-26849: Split a nonsplittable string Capture process “string” in job “string”?

In this post, you’ll learn more about the Oracle ErrorORA-26849: Split a nonsplittable string Capture process “string” in job “string” with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-26849: Split a nonsplittable string Capture process “string” in job “string”

Reason for the Error ORA-26849: Split a nonsplittable string Capture process “string” in job “string”

The job tried to split a GoldenGate, XStream or Streams Capture that was not splittable. That is, the Capture either had less than two subscribers, or it was not the only Capture of its queue.

How to fix the Error ORA-26849: Split a nonsplittable string Capture process “string” in job “string” ?

You can fix this error in Oracle by following the below steps

Drop the split job, or wait untill the GoldenGate, XStream or Streams Capture becomes splittable.