The moose likes Oracle/OAS and the fly likes Data Pump Import Question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Data Pump Import Question" Watch "Data Pump Import Question" New topic

Data Pump Import Question

Mike London
Ranch Hand

Joined: Jul 12, 2002
Posts: 1130
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:


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

Joined: Mar 30, 2009
Posts: 75
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..

Mike London
Ranch Hand

Joined: Jul 12, 2002
Posts: 1130
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:
subject: Data Pump Import Question
It's not a secret anymore!