Home » RDBMS Server » Server Utilities » how to open.dmp file
how to open.dmp file [message #358246] Mon, 10 November 2008 05:27 Go to next message
deepshikhahcl
Messages: 14
Registered: October 2008
Junior Member
Hi,

I have one DMP file that contains insert data into the table.Rather than importing that file i want to open that file and want to see in which tables the data is importing.Please let me know how to open the dump file
Re: how to open.dmp file [message #358248 is a reply to message #358246] Mon, 10 November 2008 05:46 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Use the "SHOW" parameter appropriately, or answer the "Only list content of importfile?" question appropriately.

How exactly would depend on the exact OS and Database version, which you didn't tell us.
Re: how to open.dmp file [message #358254 is a reply to message #358248] Mon, 10 November 2008 06:18 Go to previous messageGo to next message
deepshikhahcl
Messages: 14
Registered: October 2008
Junior Member
oracle 10g versio 10.1.0.4.2
OS Win XP
Re: how to open.dmp file [message #358266 is a reply to message #358254] Mon, 10 November 2008 07:03 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Then just answer "y" when the question "Only list content of importfile?" gets asked during the import, or use the "SHOW=y" parameter in the parameter file.

Read the documentation for other details.
Re: how to open.dmp file [message #358267 is a reply to message #358266] Mon, 10 November 2008 07:35 Go to previous message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In addition to SHOW=Y option, you might want to log the output into a log file (so that you wouldn't have to "remember" what you've seen on the screen); do that by using the LOG import command option.

By the way, sometimes IMP HELP=Y helps a lot.
Previous Topic: impdat
Next Topic: Import error
Goto Forum:
  


Current Time: Tue Dec 06 14:09:00 CST 2016

Total time taken to generate the page: 0.10187 seconds