My Oracle Support Banner

How To Load Data With SQL*Loader Using Named Pipes (Doc ID 1350952.1)

Last updated on AUGUST 04, 2018

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)


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

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