Import/export Log file [message #455325] |
Tue, 11 May 2010 03:21 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
MR[T]
Messages: 62 Registered: March 2009
|
Member |
|
|
Hello
Whats is the usage of log file in Import/export .If i use following command ,it exports successfully
exp scott/tiger file=check.dmp log=empc.log tables=emp
and if i remove .log from here it will also export successfully .
So why do we use .log in import/export.
Regards
Mr.T
|
|
|
|
|
|
Re: Import/export Log file [message #455546 is a reply to message #455536] |
Wed, 12 May 2010 01:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
That must be because LOG parameter isn't required for EXP and/or IMP to work properly. If everything is fine, you don't need to use LOG. If something goes wrong, it will go wrong with or without the LOG parameter. Supplying LOG won't fix any error, but (probably) will help you find out what the error was and, which is even more important, point you to the right direction so that you could - eventually - fix that error.
To cut a long story short - yes, you are right. Both EXP and IMP work without using LOG.
|
|
|