How To Load Data With SQL*Loader Using Named Pipes

(Doc ID 1350952.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 8.1.7 to 11.2]
Information in this document applies to any platform.


This note explains how to load data with SQL*Loader using named pipes based on examples.

The following environment is available:

-- input data file (ldr.dat) containing the records:

0001;Text 0001
0002;Text 0002
0003;Text 0003
1000;Text 1000

-- the table TAB001 that needs to be loaded in schema TEST:

create table tab001
   id number,
   text varchar2(20)


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