My Oracle Support Banner

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

Last updated on SEPTEMBER 24, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
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 XXX
ORA-14766: Unable to obtain a stable metadata snapshot
ORA-39776: fatal Direct Path API error loading table XXX
SQL*Loader-2026: ORA-14766: Unable to obtain a stable metadata snapshot
the load was aborted because SQL Loader cannot continue.

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
References


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