How do i go about importing a .dmp file created by DataPump into Oracle Express 10g
A:
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
2009-06-05 09:12:12