title: How to use query clause in EXPDP
body: <p>I am exporting data of a table through EXPDP by using the below command</p>
  
  <pre><code>nohup expdp \"/ as sysdba\" directory=DATA_PUMP_DIR dumpfile=EXP.dmp logfile=EXP.log version=11.2.0.4 TABLES=CRM.CATEGORIES QUERY='"where bank_id='43'"'
  </code></pre>
  
  <p>Getting the below error </p>
  
  <blockquote>
    <p>ORA-31693: Table data object "CRM"."CATEGORIES" failed to load/unload
    and is being skipped due to error:</p>
    
    <p>ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout</p>
    
    <p>ORA-01722: invalid number</p>
  </blockquote>
  
  <p>If I remove the query parameter from the export command, it works fine. I have tried changing the version parameter to different values but still getting the same error
  The BANK_ID column in the table is of NVARCHAR2 data type.
  I can't use EXP as it is blocked on the db. Oracle version is 12.1.0.2.0 for both source and destination db.</p>