Tuesday, October 15, 2013

OGG-01161: Bad column index () specified for table...

If you are getting the error below, then that means there are some DDL Changes occurred at Source and Target is kicking you out...
Main problem is DDL Replication is not enabled from Source to Target.

Here is how to resolve (if DDL Replication was not enabled at source):
1. Perform the DDL that occurred at source (could be a new column or dropping a column etc.,) in the target.
2. Login into ggsci (of-course by changing direcotry to GG Home)
3. Run @ddl_enable

That will enable all DDL changes to replicate from source to target.
Data will by synced for the other DDL's that occurred prior to this enable (because you took care of them manually) so dont worry...

No comments:

Post a Comment