Conditional export / import

 

  $ expdp '"sys/oracle as sysdba"' query=wf_inorder:\"where status_code=\'Open\'\" 

     tables=esbuser.wf_inorder DIRECTORY=DUMP_DIR1 DUMPFILE=wf_inorder_open.dmp LOGFILE=wf_inorder_exp.log 

   $ impdp '"sys/oracle as sysdba"' DIRECTORY=DUMP_DIR1 DUMPFILE=wf_inorder_open.dmp LOGFILE=wf_inorder_imp.log 

     tables = esbuser.wf_inorder  REMAP_TABLE = esbuser.wf_inorder:wf_inorder_copy;

     --------------

   $ expdp '"sys/oracle as sysdba"' query=wf_inorder:\"where status_code not in \(\'Complete\'\)\"

     tables=esbuser.wf_inorder DIRECTORY=DUMP_DIR1 DUMPFILE=wf_inorder_open_4.dmp LOGFILE=wf_inorder_exp_4.log

   $ impdp '"sys/oracle as sysdba"' DIRECTORY=DUMP_DIR1 DUMPFILE=wf_inorder_open_4.dmp LOGFILE=wf_inorder_imp_4.log 

     tables = esbuser.wf_inorder  REMAP_TABLE = esbuser.wf_inorder:wf_inorder_4;