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: 21151
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: Counter while loading via SQL Loader
Next Topic: sql loader direct path is taking more time
Goto Forum:

Current Time: Wed Aug 23 20:21:00 CDT 2017

Total time taken to generate the page: 0.05335 seconds