ORA-31530: could not find published column string for CDC subscriber view string.string
Cause: A published column was missing for an imported Change Data Capture subscription.
Action: Drop the imported subscription because it is invalid. Verify that the schema containing the missing published column was included in the original export. If needed, perform the export again, including the schema of the missing published column.
。
ORA-31530 error occurs when a user tries to work with Change Data Capture (CDC) in Oracle database and the database could not find any published column for the CDC subscriber view.
Official Explanation
Cause: No published column was found for the subscriber database.
Action: Check the subscriber column, DBA_CDE_SUBSCRIBER, for user errors.
Common Scenarios:
• The object was not created properly.
• The object was not granted appropriate privileges.
• The subscription was not configured properly.
Normal Handling:
Step 1: Check the CREATE statement of the object.
Step 2: Check the privileges granted on the object.
Step 3: If the Create statement and privileges are correct, check the subscription create statement and privileges granted on the subscription. This might resolve the issue.