When a CREATE GLOBAL TEMPORARY statement is issued on source, on target the Post process of Shareplex is locking that table due to a DDL lock. The event log shows the following errors though posting is not impacted in any way and the transactions are posting fine. Here are the event log entries:
sp_ctrl>show log reverse
Error 2017-08-07 16:58:16.032087 27216 2329409280 s:1 Poster: Skipping failed DDL Replication (posting from SID1, queue queue_name, to SID2) [module opo]
Error 2017-08-07 16:58:16.017140 27216 2329409280 s:1 Poster: 15033 - Failed to execute SQL on table "OWNER"."TABLENAME”: attempt to create, alter or drop an index on temporary table already in use (posting from SID1, queue queue_name, to SID2) [module opo]
Notice 2017-08-07 16:58:16.014760 27216 2329409280 s:1 Poster: Oracle error: ORA-14452: attempt to create, alter or drop an index on temporary table already in use rowid:N/A (posting from SID1, queue queue_name, to SID2) [module opo]
Notice 2017-08-07 16:58:16.012162 27216 2329409280 s:1 Poster: ORA-14452: attempt to create, alter or drop an index on temporary table already in use (posting from SID1, queue queue_name, to SID2) [module osp]
Notice 2017-08-07 16:58:15.985239 27216 2329409280 s:1 Poster: Replicated DDL "truncate table Table_name" (posting from SID1, queue queue_name, to SID2) [module opo]
Notice 2017-08-07 16:57:32.632051 27216 2330433280 s:1 Poster: Replicated DDL "CREATE GLOBAL TEMPORARY TABLE Table_name ON COMMIT P..." (posting from SID1, queue queue_name, to SID2) [module opo]
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center