1 Reply Latest reply: Apr 26, 2013 4:33 AM by Richard Harrison . RSS

    Export & import Activity

    974882
      Guys,

      I have to do export of one table "RELATEDEVENTS" and import the table in between the 13-APR-2013 AND 26-APR-2013.

      Kindly refer sql commads: is these are perfect for the above demand.
      expdp NFADMIN/dbsoc123nf@NFDB directory= RELATEDEVENTS_directory dumpfile=exp_RELATEDEVENTS_26April2013.dmp 
      logfile=exp_RELATEDEVENTS_27April2013.log TABLES=RELATEDEVENTS 
      impdp NFADMIN/dbsoc123nf@NFDB directory= RELATEDEVENTS_directory dumpfile=imp_RELATEDEVENTS_26April2013.dmp 
      logfile=imp_RELATEDEVENTS_27April2013.log TABLES=RELATEDEVENTS 
      QUERY=(NFADMIN.RELATEDEVENTS:"Where APPTIMESTAMP BETWEEN '13-APR-2013' AND '26-APR-2013'")
      pls let me know if any correction is required here...

      Edited by: 971879 on Apr 26, 2013 2:11 AM

      Edited by: 971879 on Apr 26, 2013 2:11 AM
        • 1. Re: Export & import Activity
          Richard Harrison .
          Hi,
          At first look the command syntax looks ok. Two things i'd suggest though:

          1) use a parfile - the query command with all the quotes and brackets will need lots of escape characters to make it work - it's far easier if you do it in a parfile
          2) do the query part on the extract - it should mean less work overall to do that.

          Then just try it out and see if it works.

          REgards,
          Harry