views:

1019

answers:

1

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

A: 

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
Alexandre Brisebois