Loading CLOB data with sqlldr (SQL*Loader)

Home
E-mail Us
Oracle Articles
New Oracle Articles

Oracle Training
Oracle Tips
Oracle Forum
Class Catalog

Remote DBA
Oracle Tuning
Emergency 911
RAC Support
Apps Support
Analysis
Design
Implementation
Oracle Support

SQL Tuning
Security
Oracle UNIX
Oracle Linux
Monitoring
Remote support
Remote plans
Remote services
Application Server
Applications
Oracle Forms
Oracle Portal
App Upgrades
SQL Server
Oracle Concepts
Software Support
Remote Support
Development
Implementation

Consulting Staff
Consulting Prices
Help Wanted!

Oracle Posters
Oracle Books
Oracle Scripts
Ion
Excel-DB

Don Burleson Blog

Loading CLOB data with sqlldr (SQL*Loader)

Oracle Database Tips by Donald Burleson

Dr. Carolyn Hamm offers this syntax for loading COB data using SQL*Loader (sqlldr). This is from her great book "Oracle Data Mining":

Loading CLOB Data with sqlldr

For example, if your files are located at c:/sw/bands/1 ensure that the numbers following filename position are the columns in the control file where this is listed. Once you have created and saved your control files, type the following SQL*Loader (sqlldr) syntax from the command line, substituting your ODMr username and password, and the location of the control files that you created:

sqlldr dmuser/pswd control = c:/loader_bands.ctl log=c:/loader_bands.log

LOAD DATA

INFILE *

replace

into table web_desc_bands

(seqnum recnum,

type constant bands,

filename position(63:79),

text LOBFILE (filename)

terminated by EOF)

BEGINDATA

10/13/1995 06:21 PM 6,897 DSCWEBDEV\Decision Suppc:\sw\bands\1

10/17/1995 12:01 PM 4,382 DSCWEBDEV\Decision Suppc:\sw\bands\2

10/17/1995 12:05 PM 4,654 DSCWEBDEV\Decision Suppc:\sw\bands\3

10/17/1995 12:11 PM 5,051 DSCWEBDEV\Decision Suppc:\sw\bands\4

Get the Complete
Oracle Utility Information

The landmark book "Advanced Oracle Utilities The Definitive Reference" contains over 600 pages of filled with valuable information on Oracle's secret utilities. This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher.

��