Oracle Sqlldr Remote

(Example done by remote debian oracleXE 10.2.0 loading to a remote solaris
10.2.0.4.0 - 64bit Production)

If you want to load data at a remote Oracle database, and you have oracle installed at your local box, you can connect entering yout remote listener info at your TNSNAMES.ora

cat /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/tnsnames.ora

REMOTESID =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.99)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = REMOTESID)
    )
  )

and calling by sqlldr arguments:

oracle@achtung:~/input$ sqlldr scott/tiger@REMOTESID control=./carga_pedidos.ctl

SQL*Loader: Release 10.2.0.1.0 - Production on Wed Jan 11 18:28:47 2012
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Commit point reached - logical record count 1
Commit point reached - logical record count 2
.....

Coffe break!