CREATE OR REPLACE DIRECTORY 
 AS MY_TABLE_SRC_DIR
'my/path/is/here/source';


GRANT READ, WRITE ON DIRECTORY  MY_TABLE_SRC_DIR TO SYSTEM WITH GRANT OPTION;

CREATE TABLE MY_TABLE
(
  FILENAME             VARCHAR2(5 BYTE),
.
.
.
)
ORGANIZATION EXTERNAL
  (  TYPE ORACLE_LOADER
     DEFAULT DIRECTORY MY_TABLE_SRC_DIR
     ACCESS PARAMETERS 
       ( records delimited by newline
      NOLOGFILE
      fields terminated by '|' 
         missing field values are null
                  )
     LOCATION (MY_TABLE_SRC_DIR:'Input_File123.TXT')
  )
REJECT LIMIT UNLIMITED
PARALLEL ( DEGREE DEFAULT INSTANCES DEFAULT )
NOMONITORING;

Sample Mapped NFS Path: /vol1/other/server/path/source1

CREATE OR REPLACE DIRECTORY 
 AS MY_TABLE_SRC_DIR
/vol1/other/server/path/source1';


GRANT READ, WRITE ON DIRECTORY  MY_TABLE_SRC_DIR TO SYSTEM WITH GRANT OPTION;

SCOTT@orcl_11g> HOST SQLLDR scott/tiger CONTROL=test.ctl LOG=test.log