Search code examples
oracle-xedatapump

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

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

Solution

  • 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