Home » RDBMS Server » Performance Tuning » Error during Merge Statment
Error during Merge Statment [message #257463] Wed, 08 August 2007 07:22 Go to next message
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....
Re: Error during Merge Statment [message #257465 is a reply to message #257463] Wed, 08 August 2007 07:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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 Go to previous messageGo to next message
pardeep
Messages: 20
Registered: June 2001
Location: Chennai
Junior Member
what it mean?
I am not getting . please tell me clearly...
Re: Error during Merge Statment [message #257493 is a reply to message #257468] Wed, 08 August 2007 08:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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 Go to previous messageGo to next message
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 ..
Re: Error during Merge Statment [message #257531 is a reply to message #257523] Wed, 08 August 2007 10:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
If so, activate the trace and see where the error comes from.

Regards
Michel
Re: Error during Merge Statment [message #257562 is a reply to message #257531] Wed, 08 August 2007 11:44 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
create Synonym for tables over dblink and then try.
Previous Topic: Creation of index
Next Topic: Index for Order by clause
Goto Forum:
  


Current Time: Tue Dec 03 18:37:02 CST 2024