Home » RDBMS Server » Server Utilities » how to know dmp file contents (11.1.0.7 windows xp)
how to know dmp file contents [message #524494] Sat, 24 September 2011 02:01 Go to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Dear all,
Is there a way to list contents of a dmp file(using expdp generate),which objects(tables/vies/procedures/packages) does it contain?
Re: how to know dmp file contents [message #524496 is a reply to message #524494] Sat, 24 September 2011 02:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use impdp and SQLFILE parameter and CONTENT=METADATA_ONLY, also EXCLUDE or INCLUDE if you want only part of the metadata.

Regards
Michel
Re: how to know dmp file contents [message #524509 is a reply to message #524496] Sat, 24 September 2011 06:15 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
hi,
I just want to the dmp file what it contains only,not to use impdp,is there a way?
Re: how to know dmp file contents [message #524513 is a reply to message #524509] Sat, 24 September 2011 09:04 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Person #1: I want to pound nail into wall. what should I do?
Person #2: Get a hammer & strike the nail.
Person #1: I don't want to use hammer. Tell me different way.
Person #2: Use the right tool for the task at hand. Now stop being obstinate.
Re: how to know dmp file contents [message #524520 is a reply to message #524509] Sat, 24 September 2011 09:30 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
andy huang wrote on Sat, 24 September 2011 13:15
hi,
I just want to the dmp file what it contains only,not to use impdp,is there a way?


This is a general answer to this kind of questions:
Use an hexadecimal editor and hack the file/program/....

Regards
Michel
Previous Topic: Skip empty tables while export
Next Topic: indexes parameters original imp
Goto Forum:
  


Current Time: Thu Mar 28 11:11:57 CDT 2024