pending distributed trans locked
I create dblinks on our Ora10g db to Ora8i db
I made some test replication on tables named OTHERS and something got wrong with
the network, hence this error appears..
SQL> insert into others(ctrlno) values('1');
insert into others(ctrlno) values('1')
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01591: lock held by in-doubt distributed transaction 1.17.57220
How do I forced remove the error tagged please...this table OTHERS is just
a test table...and it is ok to initialize it to zero, and no need for data
integrity here to hold lock.
I tried purging the DBA_2PC_PENDING and DBA_2PC_NEIGHBORS, but it still
persist. What other view does it lookup to?
Thanks a lot
Click Here to Expand Forum to Full Width