Import dmp file created by DataPump in Oracle Express 10g

Question

How can I import a .dmp file created by DataPump in Oracle Express 10g

Answer 1

Source and additional information

Put the dump files in C: \ oraclexe \ app \ oracle \ admin \ XE \ dpdump

Import Schemes

impdp -user - / - pass- schemas = -schema- directory = -directory- dumpfile = -file.dmp-

i.e:

impdp scott / tiger @ db10g schemas = SCOTT directory = TEST_DIR dumpfile = SCOTT.dmp logfile = impdpSCOTT.log

• you may need to reassign