Home » RDBMS Server » Server Utilities » Data Pump Help (10G R2)
Data Pump Help [message #441670] Tue, 02 February 2010 09:59 Go to next message
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 #441671 is a reply to message #441670] Tue, 02 February 2010 10:02 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Do an import with
show=y log=somelogfile.sql
.
This will not do a real import but will dump all contents (DDL) to somelogfile.sql
Re: Data Pump Help [message #441672 is a reply to message #441670] Tue, 02 February 2010 10:04 Go to previous messageGo to next message
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 #441673 is a reply to message #441672] Tue, 02 February 2010 10:07 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You are right. I failed to see the "data pump" in title.
Re: Data Pump Help [message #441674 is a reply to message #441672] Tue, 02 February 2010 10:08 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
perhaps "SQLFILE Write all the SQL DDL to a specified file."

or

CONTENT=METADATA
Re: Data Pump Help [message #441683 is a reply to message #441670] Tue, 02 February 2010 10:59 Go to previous messageGo to next message
salama
Messages: 36
Registered: January 2006
Member
Thanks Black Swan, I am going with the SQLFILE option of impdp
Re: Data Pump Help [message #441688 is a reply to message #441670] Tue, 02 February 2010 11:39 Go to previous message
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
Previous Topic: Pipe Delimited File Issues
Next Topic: SQL Loader
Goto Forum:
  


Current Time: Tue Nov 12 23:24:54 CST 2024