Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Help to import dmp

User_1ET6DJul 23 2021

Hi Guys,
I have no experience/knowledge on Oracle DB and I need to ask a guy to export it's Oracle DB and transfer it to me for some analyse. This person is far away, I'm not in direct contact with him.
I've made several researches and tries before writing here, but I need your help.
The dmp I received was exported using "exp" command. Size is 28 Go. Export version is 11.02.00 (that's what I get when I type "type XXXX.dmp |more" on cmd window).
I've installed Oracle XE 18c and I want now to import the dmp on my XE DB. Can you give me the correct "imp" command to do that please ? I've made lots of tries but nether get the tables I'm looking for.
If needed I can ask the guy for a new export, or some more info (ex : the "exp command line he used, DB version...")
Thanks for you help !

Comments
Post Details
Added on Jul 23 2021
2 comments
176 views