My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.