Oracle error "SQL * loader-522: lfiopn failed for file (XXX. Log )」

Run

Sqlldr username/password control = 'tbl _ EMP. CTL'

An error occurred while importing data.

 

SQL * loader-522: lfiopn failed for file (sqlldr. Log)

 

The cause of this error is that the command is not executed in the directory where the file is located.

------------------------------------------------

For example, the file directory structure is as follows:

Root

TMP

User

Our file is under TMP, But we execute this command under root.

The above error will be reported!