Oracle Tables Export Remote

If you need to export a list of tables of a remote database to the local box, you can install Oracle XE (Express Edition).
you have to include the remote LISTENER reference at your tnsnames.ora, like this:

oracle@achtung:/usr/lib/oracle$ cat /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File:

REMOTESID=
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = REMOTESID)
    )
  )
oracle@achtung:/usr/lib/oracle$

-Now you can test the asociation through tnsping utility:
tnsping REMOTESID
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 09-JAN-2012 18:06:34
Copyright (c) 1997, 2005, Oracle.  All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = REMOTESID)))
OK (60 msec)

GREAT! now you can run your remote command only with your REMOTESID string:
oracle@achtung:~$ exp USERID=luuser/password@REMOTESID -file=/home/ORA/export.dmp tables=TRANSACTIONAL,INVOICESPRO

Export: Release 10.2.0.1.0 - Production on Mon Jan 9 17:50:20 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export file: expdat.dmp > /tmp/export.dmp

Export done in UTF8 character set and UTF8 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table                  TRANSACTIONAL            0 rows exported
. . exporting table                    INVOICESPRO              36835 rows exported
Export terminated successfully with warnings.