My Oracle Support Banner

ORA-39776: Fatal Direct Path API Error Loading Table and ORA-39844 (Doc ID 2527668.1)

Last updated on OCTOBER 08, 2019

Applies to:

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

Symptoms

12.2.0.1 Data Pump Import reports ORA-39776: fatal Direct Path API error, when loading a table.

Importing from a dumpfile and over network link fails for one table with the error:

No errors are found in the alert log.

IMPDP details are:

Import: Release 12.2.0.1.0 - Production on Thu Mar 14 16:24:33 2019
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

Job: <JOB_NAME>
  Owner: ORACLE
  Operation: IMPORT
  Creator Privs: TRUE
  GUID: <GUID>
  Start Time: Thursday, 14 March, 2019 16:22:11
  Mode: SCHEMA
  Remote link:<NETWORK_LINK>
  Instance: <INSTANCE_NAME>
  Max Parallelism: 10
  Timezone: +00:00
  Timezone version: 26
  Endianness: LITTLE
  NLS character set: AL32UTF8
  NLS NCHAR character set: AL16UTF16
  EXPORT Job Parameters:
  IMPORT Job Parameters:
  Parameter Name Parameter Value:
  CLIENT_COMMAND /********@<SERVICE_NAME> parfile=<PARFILE>.par
  TRACE 0
  State: EXECUTING
  Bytes Processed: 0
  Current Parallelism: 10
  Job Error Count: 0
  Job heartbeat: 3

PARFILE is
DIRECTORY=<DIRECTORY_NAME>
network_link=<NETWORK_LINK>
logfile=<LOG_NAME>.log
schemas=<SCHEMA_NAME>
parallel=10

This import has never worked for this version/table/database

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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