OraFAQ Forum: Performance Tuning » Error during Merge Statment

Home » RDBMS Server » Performance Tuning » Error during Merge Statment

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

Error during Merge Statment [message #257463]

Wed, 08 August 2007 07:22

pardeep
Messages: 20
Registered: June 2001
Location: Chennai

Junior Member

I was inserting records from one table to another table using merge statment. At the executing time i got the following

MERGE INTO MEMST_test@MIG_MERC TGT_MEMST USING MEMST @PRESCARD STG_MERC_MST
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-02067: transaction or savepoint rollback required
ORA-02063: preceding 2 lines from MIG_MERC

What is the cause for the above error? If any noe ,please give solution.
thanks in advance....

Report message to a moderator

Re: Error during Merge Statment [message #257465 is a reply to message #257463]

Wed, 08 August 2007 07:28

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Afaik, you cannot do merge across db links.

Regards
Michel

[Updated on: Wed, 08 August 2007 08:32]

Report message to a moderator

Re: Error during Merge Statment [message #257468 is a reply to message #257465]

Wed, 08 August 2007 07:34

pardeep
Messages: 20
Registered: June 2001
Location: Chennai

Junior Member

what it mean?
I am not getting . please tell me clearly...

Report message to a moderator

Re: Error during Merge Statment [message #257493 is a reply to message #257468]

Wed, 08 August 2007 08:32

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Sorry mistyped my post and said the opposite of what I wanted.
Correction is done.

Sorry.
Michel

[Updated on: Wed, 08 August 2007 08:32]

Report message to a moderator

Re: Error during Merge Statment [message #257523 is a reply to message #257493]

Wed, 08 August 2007 09:26

pardeep
Messages: 20
Registered: June 2001
Location: Chennai

Junior Member

u mean we can't do merge across dblink..
if so,but i already used many time same ..

Report message to a moderator

Re: Error during Merge Statment [message #257531 is a reply to message #257523]

Wed, 08 August 2007 10:06

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If so, activate the trace and see where the error comes from.

Regards
Michel

Report message to a moderator

Re: Error during Merge Statment [message #257562 is a reply to message #257531]

Wed, 08 August 2007 11:44

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

create Synonym for tables over dblink and then try.

Report message to a moderator

Previous Topic:	Creation of index
Next Topic:	Index for Order by clause

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 01:53:27 CDT 2024