-
Title
Post Stopped due to error ORA-00942 -
Description
Post stopped due to error ORA-00942. Table or view does not exist in target database. -
Cause
Typo in Shareplex config file which target table name in config file does not match with target table name. -
Resolution
Workaround for one way replication, or two way replication where DDL and replicate all DDL are turn off.
1. create synonym <not_exist_owner>.<not_exist_target_table> for <intended_exit_owner>.<intended_exit_target_table>
2. edit config file in source to correct the typo
3. source sp_ctrl>activate config file
4. source sp_ctrl>flush o.<capture_source_sid> to host queue <queue_name>
5. target sp_ctrl> start post
6. Once post stopped due to flush
7 drop synonym
For example.
Post stopped due to ORA-00942 when posting HR.THE_REALS. However, target table should be HR.THE_REALZ.
create synonym HR.THE_REALS for HR.THE_REALZ.
Other workarounds such as disable object name, continue on error, or create dummy table will cause data loss, and resyncing table is needed.