ORA-12840: Cannot Access A Remote Table After Parallel/insert Direct Load Txn Compiling A Package

(Doc ID 2289797.1)

Last updated on AUGUST 18, 2017

Applies to:

Oracle Database - Standard Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

parallel_max_servers=0

alter session disable parallel dml;
alter session disable parallel query;
alter session disable parallel ddl;
Session altered.

SQL> alter package PKG_MYPKG compile body;
alter package PKG_MYPKG compile body

ERROR at line 1:
ORA-04052: An error occurred while searching for the remote object

ORA-00604: An error occurred in level 1 recursive SQL
ORA-12840: Can not access a remote table after a load transaction
Direct / parallel for insertion

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms