My Oracle Support Banner

How to Handle SQL*Loader Exit Codes (Doc ID 191041.1)

Last updated on DECEMBER 20, 2023

Applies to:

Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
HP OpenVMS VAX
HP OpenVMS Alpha
Generic UNIX
Generic Windows

Purpose

With release of Oracle 8, the SQL*Loader utility provides exit codes (also called: return codes) for checks immediately after a run.
This document aims to describe this facility and how to get the exit codes.

Note that these codes are not reported correctly in Oracle7, but should be valid in Oracle8 release 8.0.3 onwards. (See Bug:165338)

Scope

The information in the article applies to SQL*Loader utility only for users that need automatic error checking for their load jobs.
There are example scripts just to give an idea about handling the exit codes.

Details

To view full details, 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 a vibrant support community of peers and Oracle experts.