Import utility that can work on a remote computer (not on the server as Oracle Database - Data Pump - (Export|Import) Utilities).
See Oracle Database - Export Utility (exp)
imp help=y
The Export utility always exports user data, including Unicode data, in the character sets of the Export server. (Character sets are specified at database creation.) If the character sets of the source database are different than the character sets of the import database, then a single conversion is performed to automatically convert the data to the character sets of the Import server.
Only one mode (TABLES, FROMUSER, or FULL) can be specified
imp user/pwd@db FILE=myFile.DAT FROMUSER=userSource TOUSER=userTarget SHOW=Y
imp dq_src/dq_src@<ORCL or your database service name> file=<PATH>\dq_src.dmp full=y
Specifies whether to import the entire export dump file.
imp SH_TARGET/SH_TARGET FROMUSER=SH TOUSER=SH_TARGET
This parameter is relevant only to users with the IMP_FULL_DATABASE role.
IMP-00015: following statement failed because the object already exists:
"CREATE TYPE "MAX_SQL_VC2_NTT" TIMESTAMP '2014-12-09:11:20:45' OID 'CB14DC0E"
"EC4E031FE040007F01002AC4' "
" is table of varchar2(4000);"
. . skipping TOID validation on type NICOLAS.MAX_SQL_VC2_NTT
Create a log file generated with the LOG parameter.