Run Exp and Expdp in a batch file and export .dmp to a compressed RAR File.
Posted on 2011-02-26
I have an Oracle 10G R2 64Bit Database running on Windows Server 2003 R2 64bit standard edition. I am trying to run the exp and expdp command to export the complete database to a .DMP file.. Currently i am running manually by going to run command, typing exp, then entering username and password, then entering buffersize, then putting the location and then Enter 2 times...
Now, what i want to do is, I want to create 2 separate batch files in which one should trigger the exp command and the other should trigger the expdp command.
this exp command has to answer the username/pwd and then the buffersize and then the location, then it must compress the .dmp to the particular location.
this has to compress in rar format and put in a separate location.