The following warning keep appearing in the event_log after some maintenance activity on the source database involving objects in replication:
Error 2016-05-21 01:58:19.657904 26936 1 Table <owner>.<table_name> dropped from replication: Internal representation no longer valid due to indirect DDL. Re-activation is recommended.
Similar warnings also show up in the Capture log (*ocap* log):
ocap 2016-05-21 01:58:19.657904 26936 1 Table <owner>.<table_name> is removed from replication due to indirect DDL: trans=7(5).10363219-3(16354) seqno/offset=227,564545460
However, the *ocap* *ddl* log has no mention of this event so it is not clear as to what the DDL is which is resulting in this problem.
The error/warning is also associated with Oracle upgrade at times when the objects may go numerous DDL changes. At other times it can be some DDL that causes it which may not have anything to do with Oracle upgrade. Usually the warnings occur for multiple objects. The simplest solution is as follows:
Make a copy of the currently active config file.
Activate the copy.
This will result in the problem objects brought back into replication. The advantage of activating a copy and not the currently active config file is, if, for any reasons the new activation fails, then the original config file still remains active. In that event one can attempt to activate the copy at another time.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center