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!

Was given a DMP file for the 1st time

3560332Mar 8 2018 — edited Mar 9 2018

The company I contract for has a large data dump of their old Electronic Records system that they want to be exported into a readable, searchable document, like CSV. They do not have any DBA on staff nor can they pay for one and for some reason, they think the IT Support Specialist (me) should be able to do this without issue...lol

I had been following steps and am now stuck – so close!

It was done using the Oracle 11g R2 version with the exp format.

I have 11g R2 installed as well as the SQL developer application.

I selected "create and configure database" at installaion (not sure if that was the right choice.

THen I created a user in SQL plus and grant DBA rights

Then I open cmd and use "imp"

I go through the steps, and after it runs and I connect the user in sql developer, nothing is there in terms of the dmp file.

Obviously I am not a dba and am probably doing something (well I am) wrong.

What information would you need from me to see what it is that I am doing wrong?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 6 2018
Added on Mar 8 2018
21 comments
1,138 views