This discussion is archived
5 Replies Latest reply: Nov 6, 2012 4:50 AM by User286067 RSS

data pump parfile problem!

Latvian83 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    >

    >
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points