Home » RDBMS Server » Server Utilities » Compressed size EXP (Oracle10g, Widnows2003 server)
Compressed size EXP [message #323287] Wed, 28 May 2008 01:31 Go to next message
Messages: 188
Registered: April 2005
Location: Islamabad
Senior Member


I use EXP to backup users, is there any option to get compressed in size resultant backup file?

Re: Compressed size EXP [message #323298 is a reply to message #323287] Wed, 28 May 2008 02:09 Go to previous messageGo to next message
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

On unix you can use pipe to compress dump. On windows I am not aware of such tool.
Re: Compressed size EXP [message #323312 is a reply to message #323298] Wed, 28 May 2008 03:05 Go to previous messageGo to next message
Messages: 20849
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
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
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
Re: Compressed size EXP [message #325380 is a reply to message #323312] Fri, 06 June 2008 01:26 Go to previous message
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
On windows you can use winzip.I have used this one and it greatly reduce the size of your dump file.2 GB to 200MB.

Previous Topic: Change the structure of a partitioned with expdp/impdp
Next Topic: how to load data from several dat files at a time using sqlloader?
Goto Forum:

Current Time: Sat Oct 22 08:34:06 CDT 2016

Total time taken to generate the page: 0.09261 seconds