| how to open.dmp file [message #358246] |
Mon, 10 November 2008 05:27  |
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  |
ThomasG
Messages: 3212
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 #358266 is a reply to message #358254] |
Mon, 10 November 2008 07:03 |
ThomasG
Messages: 3212
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 |
 |
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
