Home » SQL & PL/SQL » SQL & PL/SQL » Merge - ora 12854
Merge - ora 12854 [message #418560] Mon, 17 August 2009 05:46 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
MERGE INTO tml_auths_arch partition(PART_20090729) t1
USING   tml_auths_arch_avw@link1  t2
ON  (t1.txn_uid = t2.txn_uid)
WHEN NOT MATCHED THEN
INSERT VALUES( t2.TXN_UID,
t2.RELATED_UID,
);  


Error.

ORA-12854: Parallel query is not supported on temporary LOBs

I find the below solution.

ORA-12854: Parallel query is not supported on temporary LOBs
Cause: The parallel query statement produced a temporary LOB.

Action: Turn off parallelism for the query or underlying table


But how to stop parallelism for the query?
Please help
Re: Merge - ora 12854 [message #418564 is a reply to message #418560] Mon, 17 August 2009 06:08 Go to previous messageGo to next message
bonker
Messages: 402
Registered: July 2005
Senior Member
What happens if you use Insert instead of Merge?

Insert into tml_auths_arch
select t2.TXN_UID,t2.RELATED_UID
from tml_auths_arch_avw@link1  t2
where not exists (select null from tml_auths_arch partition t1 where t1.txn_uid = t2.txn_uid)

Re: Merge - ora 12854 [message #418567 is a reply to message #418560] Mon, 17 August 2009 06:16 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
But how to stop parallelism for the query?

Quote:
Action: Turn off parallelism for the query or underlying table

Use ALTER TABLE.

Regards
Michel
Previous Topic: Related Tables
Next Topic: Index tablespace issue
Goto Forum:
  


Current Time: Sat Dec 03 08:05:54 CST 2016

Total time taken to generate the page: 0.08228 seconds