for devenge

[spower]

I was wondering if you could give me some advice, I am really stuck and it seems like you're the only one who knows anything about this, could you take a look at the message I posted below you last solution.

Thanks
Scott

[denevge]

I once had the same problem.

I looked on metalink, and used the document that I put in the thread.

Did you check the dba_2pc* views on the local and the remote db ?
Normally, if you have pending '2-face commits' they must appear somewhere.

Gert

[spower]

I did a very stupid thing, I thought that since the entries were in the pending table than if i deleted then there would be no more pending jobs, well I was wrong, and now I can't do no commands cause the system can't see any pending jobs.


Am I in trouble now???

Scott

[denevge]

I think this is a good question to ask oracle support.

However, i assume you deleted the data on 1 db. Since the problem is with a 2-face commit, can't you see anything on the remote db ?

Gert