title: How to use QUERY in expdp to extract only the last 3 months data
body: <p>In my other thread, I have asked how to extract only the last 3 months. However, I managed to extract data from the  last 3 months only from one table and it extracted all data for other tables. I have several tables in my schema and the column names for the timestamp are different. </p>
  
  <p>In my par file I have the following QUERY but it did not work. I got ORA-00911 error message. I would like to know if the syntax of the below query is correct/possible .</p>
  
  <pre><code>    QUERY=TABLE1,TABLE2:"where TABLE1_STARTTIME &gt;= TO_DATE('01-AUG-2015','dd-mon-yyyy') and TABLE2_STARTIME &gt;= TO_DATE('01-AUG-2015','dd-mon-yyyy');" 
  </code></pre>