Starting with Shareplex 6.0 and up, the copy table has been introduced to sync tables. It uses Oracle's Export/Import utility and has a number of options available which includes synchronizing tables not involved in replication. You issue the "copy table" and then check its status after some time with the command "copy status" to find that it fails as below:
sp_ctrl (source_servername:port_num)> copy owner.table1
copy started; job id 23
sp_ctrl (source_servername:port_num)> copy status
Job ID : 23
Host : source_servername
Started : 06-NOV-08 16:10:18
Job Type : Copy
Status : Failed - Could not lock table(s)
ID Tablename Total Rows %Comp Status Status e
------ ------------------------------------ ---------- ----- ---------- --------
1 "owner"."TABLE1" 6 Locking 44
The copy table log on source named sync_svr* log also shows that the table is locked on source as shown:
.
.
Thu Nov 06/16:10:56.489:: Locking Tables
Thu Nov 06/16:10:59.587:: 002: WARNING: Table "owner"."TABLE1" locked by owner session(1091),process(1829),mode=EXCLUSIVE(6),OSuser(oracle) at sync/oci/sync_oci_utils.cpp:154
Thu Nov 06/16:10:59.589:: Locking thread completed in 2.98172 seconds
Thu Nov 06/16:10:59.608:: Could not lock any tables requested
Thu Nov 06/16:10:59.636:: ERROR: Could not lock tables at sync/svr/sync_server.cpp:136 at sync/svr/sync_server.cpp:159
Thu Nov 06/16:10:59.733:: Logged off from Oracle, 1 OCI connections open
The same thing can be encountered when running "append table" and hence the solution applies to that command as well.
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