5 Replies Latest reply: Nov 6, 2012 6:50 AM by User286067 RSS

    data pump parfile problem!

    Latvian83
      Hello,
      I am using oracle 10.2.0.4.0 on Enterprise Linux 4.

      I am trying to perform a data pump schema-mode import using a parameter file. test.par:
      SCHEMAS=hr
      DIRECTORY= datapump
      DUMPFILE= 20110224_224230.dmp
      logfile=`date '+%Y%m%d_%H%M%S'`.log
      I am running the following command:
      impdp hr/hr parfile =test.par
      and I am getting the following error:

      LRM-00112: multiple values not allowed for parameter 'logfile'
      LRM-00113: error when processing file 'test.par'

      Why I am getting this error and how to solve it?

      Thanks in advance
        • 1. Re: data pump parfile problem!
          Lubiez Jean-Valentin
          Hello,


          I'm not sure it can work like that in a Parameter File.

          You may find here an example on the following Note of My Oracle Support:
          How To Create Dumpfile and Logfile with Timestamp in Their Names While using EXPDP [ID 737949.1]
          They build with a shell a command line which include a Timestamp for the name of the dump (or logfile).


          Hope this help.
          Best regards,
          Jean-Valentin
          • 2. Re: data pump parfile problem!
            Latvian83
            >

            >
            You may find here an example on the following Note of My Oracle Support:
            How To Create Dumpfile and Logfile with Timestamp in Their Names While using EXPDP [ID 737949.1]
            They build with a shell a command line which include a Timestamp for the name of the dump (or logfile).
            Thanks for replying. I think you missed to put the link to the mentioned note.
            • 3. Re: data pump parfile problem!
              Lubiez Jean-Valentin
              Hello,


              In fact this is a Note that you can find on My Oracle Support:

              https://support.oracle.com

              Then, on the search engine just enter the Note ID *737949.1*.

              It's a simple example. In fact put what you have written in a shell script instead of using a Parfile, and normally it will work.


              Hope this help.
              Best regards,
              Jean-Valentin

              Edited by: Lubiez Jean-Valentin on Feb 25, 2011 12:19 AM
              • 4. Re: data pump parfile problem!
                967727
                Hi everyone,

                On Windows platform this script working in BAT file. Just check with your OS in One line.

                expdp username/password@services_name directory=DATA_PUMP_DIR dumpfile='ABC_%date:~7,2%-%date:~4,2%-%date:~12,2%-%time:~0,2%-%time:~3,2%-%time:~6,2%.dmp' logfile='ABA_%date:~7,2%-%date:~4,2%-%date:~12,2%-%time:~0,2%-%time:~3,2%-%time:~6,2%.log'


                ------------
                NJ
                • 5. Re: data pump parfile problem!
                  User286067
                  logfile=`date '+%Y%m%d_%H%M%S'`.log
                  back-quoted date command will NEVER be evaluated in a parfile. It is only evaluated by shell. So, this will never work. You can either use shell script to pass in logfile parameter while all other parameters are in parfile. Or, write a procedure/package using dbms_datapump and use all features in plsql.

                  Raj