Data Loading and Unloading - Expert Oracle Database Architecture - page 700

First, we'll run this example when the user does not have the CREATE ANY DIRECTORY privilege. SQLLDR express
mode is invoked via the TABLE keyword:
$ sqlldr eoda table=dept
Password:
SQL*Loader: Release 12.1.0.1.0 - Production on Sat Mar 8 14:42:02 2014
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
Express Mode Load, Table: DEPT
Path used: External Table, DEGREE_OF_PARALLELISM=AUTO
SQL*Loader-816: error creating temporary directory object SYS_SQLLDR_XT_TMPDIR_00000 for file
dept.dat
ORA-01031: insufficient privileges
SQL*Loader-579: switching to direct path for the load
SQL*Loader-583: ignoring trim setting with direct path, using value of LDRTRIM
SQL*Loader-584: ignoring DEGREE_OF_PARALLELISM setting with direct path, using value of NONE
Express Mode Load, Table: DEPT
Path used: Direct
Load completed - logical record count 4.
Table DEPT:
4 Rows successfully loaded.
Check the log file:
dept.log
for more information about the load.
The prior output tells us that the schema did not have the privilege to create a directory object; therefore,
SQLLDR used its direct path method of loading the data. Querying the table confirms the data was successfully
loaded:
EODA@ORA12CR1> select * from dept;
DEPTNO DNAME LOC
---------- -------------- -------------
10 Sales Virginia
20 Accounting Virginia
30 Consulting Virginia
40 Finance Virginia
Now we grant the CREATE ANY DIRECTORY privilege to the user:
SYS@ORA12CR1> grant create any directory to eoda;
Grant succeeded.
To set this up again, first remove the records from the DEPT table:
EODA@ORA12CR1> truncate table dept;