Importing a dmp file created by DataPump into Oracle Express 10g

Question

How do i go about importing a .dmp file created by DataPump into Oracle Express 10g

Answer 1

Source and More Information

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

Schema Imports

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 remap