running compare/repair gives ora-942 error after applying patches
说明
Shareplex for Oracle When attempting to run compare/repair after applying patches shareplex give error
Notice: Object ID of OWNER.TABLE_NAME is 111111 Notice: Found primary key for table 111111 in de_table_find_primary_key Oracle Error: ORA-00942: table or view does not exist
Error 942 calling oexec in de_splextab_insert_row Error 1 inserting into SHAREPLEX_DATAEQUATOR table Exiting
解决办法
After applying patches shutdown shareplex and rerun ora_setup. Start shareplex and rerun the compare command. ora_setup needs to be run on both the source and target.
