Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

I need help using the impdb utility on a different machine to the export...

923498Mar 13 2012 — edited Mar 13 2012

Hi all,

I have recieved an export from a ClearQuest database, built on Oracle.

It's a 6GB file xxx_full_dpdump.dmp, with a corresponding .log.
This was exported from a different Oracle instance on a different machine.

I'd like to import this dump file into my Oracle instance.
I tried to use imp, and received the following error: IMP-00010: not a valid export file, header

After a bit of reading, I think this may becase I should be using impdp.

BUT... when trying to use impdp, I'm not sure how to structure the syntax? specifically, what is DIRECTORY?
As this is export is from a different machine, the directory that it was exported to is not on my machine.

When running ...
impdp username/password directory=MyDirectoryThatContainsTheDmp DUMPFILE=xxx_full_dpdump.dmp
... I receive:
ORA-39002: invalid operation
ORA-3970: Unable to open the log file
ORA-3907: directory name MyDirectoryThatContainsTheDpm is invalid