How to fix the Oracle error ORA-26696: no string data dictionary for object with number string and version number string from source database string?

In this post, you’ll learn more about the Oracle ErrorORA-26696: no string data dictionary for object with number string and version number string from source database string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-26696: no string data dictionary for object with number string and version number string from source database string

Reason for the Error ORA-26696: no string data dictionary for object with number string and version number string from source database string

An attempt to access the database object failed because the data dictionary for the object was either never populated or it was purged.

How to fix the Error ORA-26696: no string data dictionary for object with number string and version number string from source database string ?

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

Make sure the GoldenGate, XStream or Streams data dictionary is created by calling DBMS_CAPTURE_ADM.PREPARE_%_INSTANTIATION.