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 8.1.7.0 to 11.2.0.2 [Release 8.1.7 to 11.2]
Information in this document applies to any platform.

Goal

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)
);

Solution

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