SQL * Loader Program - Sample Example
Create the
sample concurrent program for running SQL*Loader in Oracle Application
Step 1:
Create the
Sql loader control file (.ctl) and data file placed on the server under the
path in bin directory (Example: $Custom_top/bin/ )
Step 2:
Create the Control file (.ctl): Demo_test.ctl
Load data
Infile 'D:\Sql_loader\export_dat.dat'
into table demo_test
fields terminated by
','
OPTIONALLY ENCLOSED
BY '"'
(
INDENT_NUMBER,
CHASSIS,
ENGINE,
ITEM
)
Step 3:
Create the Dat file (.dat) : export_dat.dat
Step:4
Create Table or copy the structure
another Table
Create table demo_test (INDENT_NUMBER VARCHAR2(20)
CHASSIS
VARCHAR2(100)
ENGINE
VARCHAR2(100)
ITEM
VARCHAR2(100) );
Copy the Structure
of the another table
Create table demo_test as Select * from XX_table;
Step:5
Creating the concurrent Program
Application Developer ->
Concurrent -> Executables.
Define a concurrent program executable name and choose
the execution method is “SQL*loader” and
give the execution file name (name
must be same as control file name ). Save it
Step:6
Create the Concurrent program name
Step:7
Goto Parameter Window. Create the parameter to take
server path of the data file. Define the Server path on Default value
Step :8
Assign the concurrent program under your custom responsibility
through a Request Group
Step:9
Run Program under the Custom Responsibility
After the running the concurrent program ,click “view Log”
+---------------------------------------------------------------------------+
XXTC Custom: Version : UNKNOWN
Copyright (c) 1979, 1999, Oracle Corporation. All
rights reserved.
XXTEST_SQLLDR module: XX_Test_Sqlloader_Demo
+---------------------------------------------------------------------------+
Current system time is 29-JUN-2013 13:22:05
+---------------------------------------------------------------------------+
+-----------------------------
| Starting concurrent program execution...
+-----------------------------
Arguments
------------
/u01/applebsuat/applcrp2/apps/apps_st/appl/xxtc/12.0.0/bin/export_dat.dat
------------
SQL*Loader: Release 10.1.0.5.0 - Production on Sat
Jun 29 13:22:05 2013
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 64 rows, maximum of 256000 bytes
Continuation: none specified
Path used: Conventional
Table DEMO_TEST, loaded from every logical record.
Insert option in effect for this table: INSERT
Column
Name Position Len
Term Encl Datatype
------------------------------ ---------- -----
---- ---- ---------------------
INDENT_NUMBER FIRST *
, O(") CHARACTER
CHASSIS NEXT *
, O(") CHARACTER
ENGINE NEXT *
, O(") CHARACTER
ITEM NEXT *
, O(") CHARACTER
Table DEMO_TEST:
238 Rows successfully loaded.
0 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Space allocated for bind array: 66048 bytes(64 rows)
Read buffer
bytes: 1048576
Step:10
Check the back-end
Sql developer, whether table got updated or not
Select * from
demo_test;
