Solved

Urgent   !!!  ora-12840

Posted on 2003-11-05
5
2,163 Views
Last Modified: 2007-12-19
I have a problem with this

ORA-12840: cannot access a remote table after parallel/insert direct load txn

Please send me your experience about this.... and how did you to solve this ....
0
Comment
Question by:mosorio
5 Comments
 
LVL 23

Expert Comment

by:seazodiac
ID: 9690282
this is from metalink:

ORA-12840 cannot access a remote table after parallel/insert direct load txn

Cause: Within a transaction, an attempt was made to perform distributed access after a PDML or insert direct statement had been issued.

Action: Commit/roll back the PDML transaction first, and then perform the distributed access, or perform the distributed access before the first PDML statement in the transaction.
0
 
LVL 23

Accepted Solution

by:
seazodiac earned 325 total points
ID: 9690285
I think you have to explicitly commit the parallel DML first.
0
 

Author Comment

by:mosorio
ID: 9690454
Already saw that  !!!
0
 
LVL 2

Expert Comment

by:Kong
ID: 9690538
You have to commit or rollback after PDML because your data is in an intermediate state - ie, in temporary extents from the end of your HWM & constraints disabled.
0
 
LVL 13

Expert Comment

by:anand_2000v
ID: 9693062
Kill any session which was doing a PDML or a Direct insert if you are not able to give an explicit commit or rollback
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle sql query 7 74
any step by steps guide on how to install Oracle 12c on Windows 10 8 58
Oracle Insert not working 10 32
Oracle collections 15 27
Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to recover a database from a user managed backup

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question