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