OraFAQ Forum: Server Administration » Error while selecting user

Home » RDBMS Server » Server Administration » Error while selecting user_jobs

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error while selecting user_jobs [message #173100]

Fri, 19 May 2006 07:38

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Hi,

I am getting the following error while selectting from user_jobs;

Select * from user_jobs;
ORA-01591: lock held by in-doubt distributed transaction 10.27.3609

Developers are trying to insert rows into sql server from oracle.

They had written a procedure for that.
Also created a job for this procedure.

How to resolve this?

Please help.

Thanks & regards
Salih Km

Report message to a moderator

Re: Error while selecting user_jobs [message #173163 is a reply to message #173100]

Fri, 19 May 2006 14:40

rsaluj
Messages: 13
Registered: May 2006

Junior Member

You have to check pending_trans$ and related tables and use Commit or Abort command to rectify

Report message to a moderator

Previous Topic:	DBMS_JOB submission error
Next Topic:	Server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 20:02:34 CST 2025