OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Data Pump Help (10G R2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator

Re: Data Pump Help [message #441671 is a reply to message #441670]

Tue, 02 February 2010 10:02

Mahesh Rajendran
Messages: 10707
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

Report message to a moderator

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.

Report message to a moderator

Re: Data Pump Help [message #441673 is a reply to message #441672]

Tue, 02 February 2010 10:07

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You are right. I failed to see the "data pump" in title.

Report message to a moderator

Re: Data Pump Help [message #441674 is a reply to message #441672]

Tue, 02 February 2010 10:08

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

perhaps "SQLFILE Write all the SQL DDL to a specified file."

or

CONTENT=METADATA

Report message to a moderator

Re: Data Pump Help [message #441683 is a reply to message #441670]

Tue, 02 February 2010 10:59

salama
Messages: 36
Registered: January 2006

Member

Thanks Black Swan, I am going with the SQLFILE option of impdp

Report message to a moderator

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

Report message to a moderator

Previous Topic:	Pipe Delimited File Issues
Next Topic:	SQL Loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 12:30:59 CDT 2024