Post fails with ORA-00904: <TABLE_NAME> invalid identifier (seen in event_log and errorlog.sql)
On closer inspection the columns used do not belong to the table (table name has changed)
In the config file shareplex can only read up to 65536 objects
If an object has a line number greater then 65536 then it will subtract 65536 from it and take this new table name with that line number (but have the correct columns when posting on the target) which leads to the ORA-00904
simple example
in config file with line numbers
line 1 table_name t1 # columns a b c
line 65537 table_name t65537 # columns d e f
if sql on t65537 is performed:
update t65537 set d=5, e=7 where f=4;
will result in post posting this sql:
update t1 set d=5, e=7 where f=4;
so this sql leads to ORA-00904 on post (which is recorded in the event_log and errorlog.sql on the target)
If you have more than 65536 objects in one replication then you will to split them up into more shareplex instances which all have less than 65537 objects
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center