File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Data Pump Import Question

 
Mike London
Ranch Hand
Posts: 1158
1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I was sent a DMP file today, but without the database user name and password.

So when I tried the following command, it didn't work:

prompt>impdp SYSTEM\SYSTEM DBFILE.DMP

Is there some other variation on the impdp command I should try to see if I can import the DMP file to create a local Oracle XE database?

Currently, the command above just comes back and asks for a password.

Thanks in advance.

-- Mike
 
Sona Patel
Ranch Hand
Posts: 75
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Mike,

I usually use 'imp' command. It is interactive command and asks for many details but we can use the default values suggested by it.
It asks for user id and password where we can provide any user with DBA rights.

If you open .dmp file with any advanced text editor then you will be able to see user name and other sql statements.

Hope this helps..

Regards,
 
Mike London
Ranch Hand
Posts: 1158
1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for your note.

I opened the DMP with a hex editor, but the password I saw there didn't work.

In any case, it sounds like I really need to get the login creds to use this DMP file....I just wanted to make sure I wasn't missing something obvious.

Thanks again!!!

- Mike
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic