A config was activated with the wrong target table name. The post is stopped due to error ORA-942 table does not exist.
The post is trying to post to a table that does not exist on the target and is getting an oracle error ORA-942 table or view does not exist.
The following steps will bypass this issue and cause the table to go out of sync :
1. Edit the config file and correct the target table typo.
2. Activate the fixed config on the source
3 issue a flush on the source sp_ctrl> flush o.sid
4. set the SP_OPO_DISABLE_OBJECT_NUM on the target sp_ctrl> set param SP_OPO_DISABLE_OBJECT_NUM <source object_id>
5 start the post process, it will run ignoring the one table until it processes the flush, after which the post will be stopped due to flush.
6 unset the SP_OPO_DISABLE_OBJECT_NUM on the target sp_ctrl> reset param SP_OPO_DISABLE_OBJECT_NUM
7 start the post
8 compare/repair the table to bring it back into sync.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center