SQL*Loader - Direct-Path Load

Card Puncher Data Processing

About

The direct path load in SQL*Loader

Specifying a Direct Path Load

To start SQL*Loader in direct path load mode, set the DIRECT parameter to true on the command line or in the parameter file, if used, in the format:

DIRECT=true

Reference





Discover More
Card Puncher Data Processing
Oracle - SQL*Loader

A utility data loader for the Oracle database Reason: NLS_NUMERIC_CHARACTERS is equal to ',.' or '.,' based upon the Territory (NLS_LANG) you are in. Example: The NLS_LANG...
Card Puncher Data Processing
Oracle Database - Direct (path insert|load) (/*+ APPEND */)

A direct-path insert is also known as: direct load A direct-path insert is a bulk operation which will only bypass redo log generation in three cases : the database is in NOARCHIVELOG mode database...
Card Puncher Data Processing
Oracle Database - Index (indices)

in Oracle Create Statement for columns table: The LOGGING/NOLOGGING setting determines if operations are...
Card Puncher Data Processing
SQL*Loader - Loading a Csv File

How to load a csv file in a table with SQL Loader. The content of the data file data.csv is: This data must be loaded in the table MY_TABLE. See below. The content of the control file load_data.ctl...



Share this page:
Follow us:
Task Runner