Data Pump Import Question

[Mike London]

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]

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]

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