title: query parameter of impdp
body: <p>I'm trying to import and dmp files into a specific table in my DB.</p>
  
  <p>I'm running this command:</p>
  
  <pre><code>impdp '/ as sysdba' directory=exp
  dumpfile=exp_01.dmp,exp_02.dmp 
  logfile=log_01.log 
  table_exists_action=truncate 
  parallel=8 
  tables=my_user.my_tbl 
  query=my_user.my_tbl: "where trunc(sysdate)-730 &gt; to_date(snapshot_month, 'yyyy/mm')
  </code></pre>
  
  <p>It's raise an exception</p>
  
  <blockquote>
    <p>LRM-00116: syntax error at ')' following 'yyyy/mm'</p>
  </blockquote>
  
  <p>This is the correct where clause and I checkd it against the table with a simple query.</p>
  
  <p>I tried to change the double comma to single comma (and adding one to the to_date format) and so on but any change that I did it didn't worked.</p>
  
  <p>In the net there are also several syntax options for the query parameter (double\single commas).</p>