Skip to content

12c SQL loader express mode

In Oracle Database12c, SQL*Loader has a new feature called express mode that makes loading CSV files faster and easier. With express mode, there is no need to write a control file for most CSV files you load. Instead, you can load the CSV file with just a few parameters on the SQL*Loader command line.

Example :

SQL> create table dept(deptno number,deptname varchar2(20),deptlocation varchar2(20));

Table created.

SQL> desc dept;
Name Null? Type
—————————————– ——– —————————-

oracle:oradb]$ cat testload.dat
001,IT Dept,Riyadh
003,HR Dept,Bahrain


[premiadb:oracle:testdb]$ sqlldr userid=testme data=testload.dat table=dept

SQL*Loader: Release – Production on Mon Jan 15 09:28:42 2018

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

Express Mode Load, Table: DEPT
Path used: External Table, DEGREE_OF_PARALLELISM=AUTO

Table DEPT:
3 Rows successfully loaded.

Check the log files:
for more information about the load.
[premiadb:oracle:testdb]$ sqlplus testme

SQL*Plus: Release Production on Mon Jan 15 09:28:58 2018

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Enter password:
Last Successful login time: Mon Jan 15 2018 09:28:45 +03:00

Connected to:
Oracle Database 12c Enterprise Edition Release – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select * from dept;

———- ——————– ——————–
1 IT Dept Riyadh
2 Accounting Riyadh
3 HR Dept Bahrain


For more detail, Please refer

Click to access sqlldr-express-mode-wp-1991038.pdf


One Comment Post a comment

Trackbacks & Pingbacks

  1. 12c SQL loader express mode - SSWUG.ORG

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: