niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » Oracle
Problem to arrange a compress on the fly to an export
Post new topic   Reply to topic Page 1 of 1 [4 Posts] View previous topic :: View next topic
Author Message
Mark D Powell
*nix forums Guru


Joined: 23 Apr 2005
Posts: 701

PostPosted: Tue Jul 18, 2006 1:44 pm    Post subject: Re: Problem to arrange a compress on the fly to an export Reply with quote
Frank van Bortel wrote:
Quote:
etantonio@libero.it schreef:

Good Morning,
I need to arrange an export and at the same time compress the result,
I want to do this in a shell script, at the moment I use this

exp sc/sc@ab1 PARFILE=exp_param.dat FILE=ciao.dmp LOG=ciaolog.txt
|compress &

and I also have no result with the following form

exp sc/sc@ab1 compress=y PARFILE=exp_param.dat FILE=ciao.dmp
LOG=ciaolog.txt

Thanks for your help

Antonio D'Ottavio
www.etantonio.it/en

Do NOT use compress=y on the export command line as parameter - it will
ruin your space allocations, not compress your generated output.
What errors do you have?

Antonio, the exp parameter compress has to do with how Oracle
calculates the initial extent size in table/index storage clauses. The
default is "compress=y" and this results in Oracle calculating the
initial extent as the full allocated size of the object which can cause
problems when you try to import the file into test environments. I
usually code an explicit compress=n so that if I use the export table
definition and load it the table takles as little space as possible.

To compress the export file either export into a named pipe as another
poster suggested and have the OS compress utility feed off the pipe or
just write the file and run compress on it after the export operation
completes.

HTH -- Mark D Powell --
Back to top
Brian Peasland
*nix forums Guru


Joined: 04 Apr 2006
Posts: 301

PostPosted: Tue Jul 18, 2006 12:52 pm    Post subject: Re: Problem to arrange a compress on the fly to an export Reply with quote
etantonio@libero.it wrote:
Quote:
Good Morning,
I need to arrange an export and at the same time compress the result,
I want to do this in a shell script, at the moment I use this

exp sc/sc@ab1 PARFILE=exp_param.dat FILE=ciao.dmp LOG=ciaolog.txt
|compress &

and I also have no result with the following form

exp sc/sc@ab1 compress=y PARFILE=exp_param.dat FILE=ciao.dmp
LOG=ciaolog.txt

Thanks for your help

Antonio D'Ottavio
www.etantonio.it/en


Try exporting to a pipe and then have compress read from the
pipe...similar to the following:

mknod exp.pipe p
exp u/p@tns parfile=my_parfile file=exp.pipe log=exp.log &
compress < exp.pipe > my_dump.compressed &

Alternatively, this works great with gzip. The last line would be:

gzip < exp.pipe > my_dump.gz &

To import, uncompress into the pipe and have imp read from the pipe.

HTH,
Brian

--
===================================================================

Brian Peasland
dba@nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown
Back to top
frank.van.bortel@gmail.co
*nix forums Guru


Joined: 11 Sep 2005
Posts: 832

PostPosted: Tue Jul 18, 2006 11:22 am    Post subject: Re: Problem to arrange a compress on the fly to an export Reply with quote
etantonio@libero.it schreef:

Quote:
Good Morning,
I need to arrange an export and at the same time compress the result,
I want to do this in a shell script, at the moment I use this

exp sc/sc@ab1 PARFILE=exp_param.dat FILE=ciao.dmp LOG=ciaolog.txt
|compress &

and I also have no result with the following form

exp sc/sc@ab1 compress=y PARFILE=exp_param.dat FILE=ciao.dmp
LOG=ciaolog.txt

Thanks for your help

Antonio D'Ottavio
www.etantonio.it/en

Do NOT use compress=y on the export command line as parameter - it will
ruin your space allocations, not compress your generated output.
What errors do you have?
Back to top
etantonio@libero.it
*nix forums beginner


Joined: 18 Jul 2006
Posts: 3

PostPosted: Tue Jul 18, 2006 10:19 am    Post subject: Problem to arrange a compress on the fly to an export Reply with quote
Good Morning,
I need to arrange an export and at the same time compress the result,
I want to do this in a shell script, at the moment I use this

exp sc/sc@ab1 PARFILE=exp_param.dat FILE=ciao.dmp LOG=ciaolog.txt
|compress &

and I also have no result with the following form

exp sc/sc@ab1 compress=y PARFILE=exp_param.dat FILE=ciao.dmp
LOG=ciaolog.txt

Thanks for your help

Antonio D'Ottavio
www.etantonio.it/en
Back to top
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [4 Posts] View previous topic :: View next topic
The time now is Fri Nov 21, 2008 9:08 pm | All times are GMT
navigation Forum index » Databases » Oracle
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Unknown in header problem -SOLVED- Light Speed Postfix 0 Thu Jul 03, 2008 10:40 am
No new posts problem with sending mail nuxia Postfix 0 Mon Apr 21, 2008 3:58 am
No new posts Postfix 2.3.8 Virtual problem Blotto Postfix 0 Fri Apr 04, 2008 6:11 am
No new posts Postfix sending problem for local domain remote email monkey_magix Postfix 0 Mon Sep 10, 2007 10:17 am
No new posts bounce problem murkis Postfix 0 Sun Oct 08, 2006 3:45 pm

Outsourcing | Loans | Mortgages | Books | Buy Anything On eBay
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group

[ Time: 0.3281s ][ Queries: 20 (0.2471s) ][ GZIP on - Debug on ]