SQL*Loader Job Fails With Error ORA-14766 Unable To Obtain A Stable Metadata Snapshot (Doc ID 1450217.1)

Last updated on OCTOBER 21, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 21-Oct-2013***

Symptoms

The following errors are being reported in the SQL*Loader log:

SQL*Loader: Release 11.2.0.3.0 - Production on Wed Oct 26 15:11:29 2011
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Load completed - logical record count 2000000.

SQL*Loader: Release 11.2.0.3.0 - Production on Wed Oct 26 15:11:29 2011

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Load completed - logical record count 2000000.
ORA-39776: fatal Direct Path API error loading table "SFCDM"."F_LOAN_ALL"
ORA-14766: Unable to obtain a stable metadata snapshot
ORA-39776: fatal Direct Path API error loading table "SFCDM"."F_LOAN_ALL"
SQL*Loader-2026: ORA-14766: Unable to obtain a stable metadata snapshot
the load was aborted because SQL Loader cannot continue.

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