My Oracle Support Banner

SQL*Loader-500: Unable To Open File Network Drive On Windows (Doc ID 2284200.1)

Last updated on OCTOBER 03, 2019

Applies to:

Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)
NOTE: In the images and/or the document content below, the user information and data used represents fictitious data. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Symptoms

You are on the Microsoft Windows platform.

When trying to load data through SQL*Loader while using a Network Drive, it fails with the following errors:

ORA-27369: job of type EXECUTABLE failed with exit code: 1
SQL*Loader-500: Unable to open file (Z:\is\MYDATA.TXT)
SQL*Loader-553: file not found
SQL*Loader-509: System error: The system cannot find the file specified.
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.

The sqlldr load fails when the datafile resides on a network drive.

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
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.