Which two statements are true about the command?

On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table
in the hr schema by issuing the command:
S>sqlldrhr/hr@pdb table=employees
Which two statements are true about the command?

On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table
in the hr schema by issuing the command:
S>sqlldrhr/hr@pdb table=employees
Which two statements are true about the command?

A.
It succeeds with default settings if the employees table exists in the hr schema.

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.

E.
It succeeds and creates the employees table in the HR schema.

Show Hint

Leave a Reply 14

Your email address will not be published. Required fields are marked *

MJ

MJ

B and D might be better answers. That command line is looking deficient of those parameters.

Reply

MJ

MJ

The given answer is correct. I made the mistake of thinking the command was executed from the OS command line when it is actually executed from SQL Plus.

Reply

MJ

MJ

Unless I’m wrong again. Can sqlldr be invoked from the SQLPlus command line or does it have to be run from the OS command line?

Reply

DBA_Contributer

DBA_Contributer

A is the absolute correct answer.
Among others only C is approximately correct one.

Reply

goszczu

goszczu

I’d also go for A,C

B – incorrect

sqlldr scott/tiger CONTROL=ulcas1.ctl READSIZE=1000000

E-incorrect

because sqlloader doesn’t create tables

Reply

goszczu

goszczu

C incorrect
I’m not completely sure but i’ve found this:

EXTERNAL_TABLE – when the EXECUTE option is specified, you must have the CREATE ANY DIRECTORY privilege (but default is “not used” so CREATE ANY DIRECTORY priv is not neeeded).

Reply

goszczu

goszczu

MY mistake – I mean that C is correct
CREATE ANY DIRECTORY is not needed in that case

Reply

Roshan

Roshan

[ora12c@RHIS-OF-APP01 admin]$ sqlldr hr/hr@PDB_1 employees

SQL*Loader: Release 12.1.0.2.0 – Production on Wed Nov 1 20:15:18 2017

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

SQL*Loader-500: Unable to open file (employees.ctl)
SQL*Loader-553: file not found
SQL*Loader-509: System error: No such file or directory

B is ok

Reply

muhaha03

muhaha03

dude, ur command is different from this

Reply