This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
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


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Data Pump Import Question" Watch "Data Pump Import Question" New topic
Author

Data Pump Import Question

Mike London
Ranch Hand

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

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..

Regards,
Mike London
Ranch Hand

Joined: Jul 12, 2002
Posts: 1064
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
 
subject: Data Pump Import Question