Home » RDBMS Server » Server Utilities » Reading an .dmp file
Reading an .dmp file [message #71287] Wed, 09 October 2002 11:11 Go to next message
Mark Fritz
Messages: 1
Registered: October 2002
Junior Member
How can I read the contents of an dump .dmp file? Do I need a utility to read the contents?

Report message to a moderator

Re: Reading an .dmp file [message #71290 is a reply to message #71287] Wed, 09 October 2002 12:17 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
Use import show=y full=y rows=n log=yourlogfile file=yourdumpfile

This will create a text file and will do nothing to the database.

Report message to a moderator

Re: Reading an .dmp file [message #71398 is a reply to message #71287] Sun, 27 October 2002 22:20 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
It is a binary file and you can SHOULD READ IT ONLY with any binary editor for your platform.

On Solaris use vim -b filename.dmp . Some DBA edit the file to change the datafiles locations and names but that might corrupt the dump file and it is not supported by Oracle.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: database not open
Next Topic: Export Import affecting sequence triggers.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 15 08:20:33 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.