5 Replies Latest reply on Jul 11, 2018 4:37 PM by jgarry

    About Impdp

    user639304


      Hello Experts,

       

      I has an expdp dump file, named ERP.DMP, of a schema ERP from an Oracle Database named PROD.  In this ERP schema, there is a table orders with 150 millions rows, and a there is a column do (of type date). Now, using impdp, I would want to import ERP.DMP in  the ERP schema of a database named TEST. But I would want  that during the import process of the table orders, only the rows verifying dco > to_date('30/06/2018','dd/mm/yyyy') be imported. Is it possible to add this condition in the impdp command?

       

      Thanks.