event_log:
Notice 2013-02-18 09:45:30.203396 3038 1109395776 s:2 Poster: ORA-00904: "<NEW COLUMN NAME>": invalid identifier. (posting from ORA11GR2, queue <name>, to ORA11GR2) [module osp]
opo log:
opo 2013-02-18 09:45:30.203920 3038 1109395776 s:2 Process_PER_Result: Unexpected PER_CHECK error(table:"<TARGET TABLE_OWNER>"."<TARGET TABLE NAME>") oracle rc=904 ../src/opst_mt/sql.cpp:9877
Target table structure and post object cache structure mismatch.
WORKAROUND:
1. Compare source and target table structure and add column on target if missing
2. Compare post object cache dump with post table structure and make sure they are the same. See solution 17525 on how to dump post object cache.
https://support.quest.com/shareplex/kb/17525
3. If post object cache is missing information, then follow instruction in solution 125456 to copy object cache from source to target
https://support.quest.com/shareplex/kb/125456
4. Start post
STATUS:
ST107187 which may cause this error with adding column on vertically partitioned table (ddl replication off) is resolved in 8.0.1.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center