How do i go about importing a .dmp file created by DataPump into Oracle Express 10g
Asked
Active
Viewed 1.1k times
1 Answers
4
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
- 6,599
- 12
- 50
- 69