Compressed size EXP [message #323287] |
Wed, 28 May 2008 01:31 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
weekend79
Messages: 198 Registered: April 2005 Location: Islamabad
|
Senior Member |
![halfday_79%40yahoo.com](/forum/theme/orafaq/images/yahoo.png)
|
|
Hi
I use EXP to backup users, is there any option to get compressed in size resultant backup file?
Wishes
|
|
|
|
Re: Compressed size EXP [message #323312 is a reply to message #323298] |
Wed, 28 May 2008 03:05 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
I'm not sure I understood the question but - if you want to compress export file, there are numerous archivers (Winzip, Winrar, just to mention the most popular in my part of the world). GUI versions won't let you compress DMP file without doing it manually, but there's a command line version available as well. It may be included into a batch file you use to perform export and - once the export is done - it will compress the DMP file.
So, if that's what you are looking for, ZIP line in the batch script might look like this:c:\pkzip -a -ex F:\baza.zip F:\baza.dmp
Also, although you didn't ask for it, perhaps you'll be interested in adding current date to DMP file name:@echo off
setlocal
for /f "tokens=2" %%i in ("%date:/=_%") do set vdate=%%i
for /f "tokens=1,2 delims=:" %%i in ("%time: =%") do set vdate=%vdate%_%%i%%j
c:\oracle\product\10.2.0\db_1\bin\exp.exe userid=scott/tiger@orcl file=e:\syr%vdate%.dmp owner=scott
endlocal
echo on
When executed:
c:\> test.bat
c:\oracle\product\10.2.0\db_1\bin\exp.exe userid=scott/tiger@orcl file=e:\syr07_19_2006_803.dmp owner=scott
|
|
|
|