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 and later
Information in this document applies to any platform.
***Checked for relevance on 07-Jan-2014***


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


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