Direct Path Load Using OCI or SQL*Loader Causes Unexpected ORA-00942 with Client/Server Mismatch (Doc ID 458010.1)

Last updated on JULY 17, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 07-Jan-2014***

Symptoms

Attempting to load data via the Direct Path Load API may fail with:


ORA-00942: table or view does not exist


When the client version is later or newer then the target database.

NOTE: OCI applications using the Direct Path Load API calls or other applications that also expose the Direct Path feature may encounter this issue. i.e SQLLOADER executing a data load with Direct Path enabled.

 
The error stack for SQLLOADER may look similar to the following:


 SQL*Loader-951: Error calling once/load initialization
 ORA-00942: table or view does not exist

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