Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

distributed transaction waiting for lock

561274Oct 21 2007 — edited Nov 17 2007

Hello,

I am getting the ORA-02049: timeout: distributed transaction waiting for lock
error. Though my system contains the multiple databases. The SQL I use INSERT /*+ APPEND */() select * from table doesn't uses any remote tables via tables.

But it is using the other schema tables in that local database. Is it causing the problem. If yes what is the solution for the same.

Please help me.

Thanks

Sathish

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 15 2007

Added on Oct 21 2007

#general-database-discussions

2 comments

1,445 views