Home » RDBMS Server » Server Utilities » Zipping a DMP File
icon14.gif  Zipping a DMP File [message #145303] Wed, 02 November 2005 06:10 Go to next message
vivek_g_r
Messages: 15
Registered: May 2005
Junior Member
Hi,

I have to regularly export some tables to a .dmp, zip it and send it thru mail. Is there any option to make a zip file, while exporting self.

Plz help in this regard.

Thanks & Regards'

R.Vivekanandaan

Report message to a moderator

Re: Zipping a DMP File [message #145310 is a reply to message #145303] Wed, 02 November 2005 07:00 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Nothing by default.
In unix, you can use pipes to read the .dmp file (in parallel, while the .dmp is being created) and great a compressed one.
Windows does not support pipes.
so you can script it ( something like this).
http://www.orafaq.com/forum/t/27184/0/
Whatever it is, never edit the .dmp and apply cauting while emailing the file as attachment. The mail transfer may corrupt the file. THe best method is to FTP the file with bin option enabled.

Report message to a moderator

Previous Topic: 8i exp to 9i imp
Next Topic: exporting in Sun Solaris
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 23:46:19 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.