Data Pump Help [message #441670] |
Tue, 02 February 2010 09:59 |
salama
Messages: 36 Registered: January 2006
|
Member |
|
|
Gentlemen,
I have a data pump export file from a client but unfortunately they did no include the export log. What is the command that I can use in order to get a list of the dump file contents like the schema information etc.
Thanks.
|
|
|
|
Re: Data Pump Help [message #441672 is a reply to message #441670] |
Tue, 02 February 2010 10:04 |
salama
Messages: 36 Registered: January 2006
|
Member |
|
|
Thanks Mahesh, I was under the impression that the show=y was for the old import utility and data pump had a different command? Perhaps I am wrong.
|
|
|
|
|
|
Re: Data Pump Help [message #441688 is a reply to message #441670] |
Tue, 02 February 2010 11:39 |
salama
Messages: 36 Registered: January 2006
|
Member |
|
|
I am having trouble using SQLFILE option, here is an example
$ impdp hr/hr DIRECTORY=dpump_dir1 DUMPFILE=expfull.dmp
SQLFILE=dpump_dir2:expfull.sql
My question is the username/password that I am suppose to specify is the username/password of the target database where I am importing, or I need to have the username/password that was used to create the data pump export file
Also regarding the DIRECTORY parameter, is that a default name or we have to specify a name where the dump file resides, I tried doing that but get an error. Any ideas guys. Thanks
|
|
|