title: Populate indexed table in Oracle using Informatica
body: <p>I'm new to both Oracle and Informatica.
  Currently working on a small task where I need to select all records from the source table, filter the results to get only records where field1='Y' and finally insert new rows into the target table that contains only src.field2 and src.field3 values.</p>
  
  <p>These 2 fields are used for the PK and for the Index of the target table.</p>
  
  <p>So i get an error  in Informatica: </p>
  
  <blockquote>
    <p>"ORA-26002: Table has index defined upon it"</p>
  </blockquote>
  
  <p>I rather not dropping the index? is there a work around?</p>
  
  <p>I've tried alter index to "unusable" but I got the same error.</p>
  
  <p>Please advice.</p>
  
  <p>Thanks.</p>