Tuesday 29 May 2012

ORA-31475: redo log catalog contains no metadata for the source table

ORA-31475: redo log catalog contains no metadata for the source table

Cause: While advancing a change set, an CDC attempted to query the LogMiner dictionary system tables to obtain the columns from the source table. The query returned no rows. This may be because none of the redo logs contains a catalog, or it may be an internal error.

Action: First, verify that the source system contains the source table. execute dbms_logmnr_d.build procedure to populate the redos log with logminer dictionary information. If this has been done and the problem persists, then contact Oracle Corporation

No comments:

Post a Comment