title: how can I use "impdp" command importing .dmp data with port number?
body: <p>I am trying to import data to an Oracle database. I have ".imp" and ".dmp" files for importing data. The database is using port 1521 and database name is "DB". 
  I have tried the following command, but doesn't work. </p>
  
  <pre><code>impdp root/password@xxx.xxx.xxx.xxx:1521:DB 
      dumpfile=transmart.dmp
      logfile=transmart.imp
      schemas=i2b2hive,i2b2metadata,i2b2sampledata,i2b2demodata,i2b2workdata
               ,biomart,biomart_user,deapp,searchapp,tm_cz,tm_lz,tm_wz
  </code></pre>
  
  <p>ERROR: either <strong>ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA</strong> or <strong>ORA-12545: Connect failed because target host or object does not exist</strong></p>
  
  <p>I can telnet the IP and port with no problem. </p>
  
  <p>Can anyone suggest please? </p>
  
  <p>Thanks!</p>