title: How to specify Oracle database schema name in Sqoop import command
body: <p>I have an oracle schema/user U1 (password P1) which contains table T1.
  There is another oracle schema/user U2 (password P2) which has read permission on table U1.T1.</p>
  
  <p>How can I import T1 using credentials U2/P2. The following command doesn't seem to work.</p>
  
  <pre><code>sqoop import --connect jdbc:oracle:thin:@//localhost:1521/xe --username U2 --password P2 -m 1 --table U1.T1
  </code></pre>
  
  <p>Logs on running with --verbose flag</p>
  
  <pre><code>16/10/19 20:52:23 DEBUG manager.OracleManager: Using column names query: SELECT t.* FROM T1 t WHERE 1=0
  16/10/19 20:52:23 DEBUG manager.SqlManager: Execute getColumnInfoRawQuery : SELECT t.* FROM T1 t WHERE 1=0
  16/10/19 20:52:23 DEBUG manager.OracleManager: Creating a new connection for jdbc:oracle:thin:@//localhost:1521/xe, using username:U2
  16/10/19 20:52:23 DEBUG manager.OracleManager: No connection paramenters specified. Using regular API for making connection.
  16/10/19 20:52:24 INFO manager.OracleManager: Time zone has been set to GMT
  16/10/19 20:52:24 DEBUG manager.SqlManager: Using fetchSize for next query: 1000
  16/10/19 20:52:24 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM TABLE_NAME t WHERE 1=0
  16/10/19 20:52:24 DEBUG manager.SqlManager: Found column xxxxxxxxxx of type [2, 19, 0]
  16/10/19 20:52:24 DEBUG manager.SqlManager: Found column xxxxxxxxxxxxx of type [12, 36, 0]
  16/10/19 20:52:24 DEBUG manager.SqlManager: Found column xxxxxxxxxxxxx of type [-9, 512, 0]
  ....
  16/10/19 20:52:24 DEBUG manager.OracleManager$ConnCache: Caching released connection for jdbc:oracle:thin:@//localhost:1521/xe/U2
  16/10/19 20:52:24 ERROR tool.ImportTool: Imported Failed: There is no column found in the target table T1. Please ensure that your table name is correct.
  </code></pre>