Home » RDBMS Server » Server Utilities » Import/export Log file (10g)
Import/export Log file [message #455325] Tue, 11 May 2010 03:21 Go to next message
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 #455327 is a reply to message #455325] Tue, 11 May 2010 03:23 Go to previous messageGo to next message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Why do people log any operation? So that you'd see what was going on (during export or import in your case). If you don't care, don't use it. Just don't come back saying "export doesn't work" or "export completed successfully, but I can't import anything".
Re: Import/export Log file [message #455360 is a reply to message #455327] Tue, 11 May 2010 06:05 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Once again a Good Post BY Little foot

sriram Smile
Re: Import/export Log file [message #455536 is a reply to message #455325] Wed, 12 May 2010 01:23 Go to previous messageGo to next message
MR[T]
Messages: 62
Registered: March 2009
Member
Thanks for the reply ..right now both imp/exp are working for me fine without using .log
Re: Import/export Log file [message #455546 is a reply to message #455536] Wed, 12 May 2010 01:56 Go to previous message
Littlefoot
Messages: 21808
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.
Previous Topic: Schema impdb invalid statement error
Next Topic: Skip One table while Import (exp/imp)
Goto Forum:
  


Current Time: Fri Apr 26 21:53:03 CDT 2024