On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR
schema by issuing the following command:
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command?
A.
It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the
database.
B.
It fails because no SQL *Loader data file location is specified.
C.
It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
D.
It fails because no SQL *Loader control file location is specified.
Explanation:
Note:
* SQL*Loader is invoked when you specify the sqlldr command and, optionally, parameters that establish
session characteristics.
Only A is correct!
C is wrong. If user does not have create any directory privilege, Sqlldr will fail to load data by external table, sqlldr will automatically switch to use direct path load. One example is
[oracle@node13 ~]$ sqlldr hr/hr@pdb1 table=employee
SQL*Loader: Release 12.2.0.1.0 – Production on Mon Jun 12 15:57:46 2017
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Express Mode Load, Table: EMPLOYEE
Path used: External Table, DEGREE_OF_PARALLELISM=AUTO
SQL*Loader-816: error creating temporary directory object SYS_SQLLDR_XT_TMPDIR_00000 for file employee.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: EMPLOYEE
Path used: Direct
Load completed – logical record count 4.
Table EMPLOYEE:
3 Rows successfully loaded.
Check the log file:
employee.log
for more information about the load.
[oracle@node13 ~]$ sqlplus hr/hr@pdb1
SQL> alter session set nls_date_format = ‘YYYY-MM-DD HH24:MI:SS’;
Session altered.
SQL> select * from employee;
EMPNO EMPNAME SAL HIRE_DATE
———- ——————– ———- ——————-
101 Jackey 2000 2012-04-15 00:00:00
102 Black Smith 3000.5 2010-09-01 13:00:00
103 Crestina Ronaledo 6000.123 2007-12-31 09:30:50
Correct answer should be A and C