How to fix the Oracle error ORA-26705: cannot downgrade capture process after Streams data dictionary has been upgraded?

In this post, you’ll learn more about the Oracle ErrorORA-26705: cannot downgrade capture process after Streams data dictionary has been upgraded with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-26705: cannot downgrade capture process after Streams data dictionary has been upgraded

Reason for the Error ORA-26705: cannot downgrade capture process after Streams data dictionary has been upgraded

An attempt was made to downgrade a capture process after it has upgraded the GoldenGate, XStream or Streams data dictionary.

How to fix the Error ORA-26705: cannot downgrade capture process after Streams data dictionary has been upgraded ?

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

Drop the capture process before attempting the downgrade.