Search code examples
oracledatapump

Datapump import is unable to open the log file

I'm trying to import the Oracle BISAMPLE.dmp schema and I've got this error ( unable to open the log file )

enter image description here

Solution

  • The argument to the directory parameter is the name of an Oracle directory object, not a direct reference to the operating system directory.

    If you do not already have an Oracle directory object pointing to that operating system directory, which has to be on the database server not a client machine, you (as DBA) will have to create it, and grant privileges to any other Oracle users who will need to use it.

    For example:

    create directory MY_DATAPUMP_DIR as 'C:\installs\datapumpdir`;

    and then

    impdp directory=MY_DATAPUMP_DIR dumpfile=...

    Alternatively you can move your .dmp file to the default directory, and either omit the directory parameter or specify the default for that, DATA_PUMP_DIR.

    Also, note the big warning from the documentation:

    Do not invoke Import as SYSDBA, except at the request of Oracle technical support. SYSDBA is used internally and has specialized functions; its behavior is not the same as for general users.