ORA-904 %s: invalid identifier / invalid column name. (4224560)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

ORA-904 %s: invalid identifier / invalid column name.
Description

Post queue backlogged due to multiple ORA-904 %s: invalid identifier / invalid column name.
Cause

Target table missing columns.
Resolution

1. Export/import target table to sync up target table structure using Oracle's Export/Import Utilties.

2. Manually create missing table columns via SQL statements. For example:
sql> alter table <table> add <column>

3. Enable DDL replication:
sp_ctrl> set param SP_OCT_REPLICATE_DDL = 3

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title