Thanks for the info. I will probably all the ideas tomorrow!

John, I believe Solaris 5.6 32bit version does not support files bigger
then 2gb at all. I know when I done the export and it hit 2gb the
export errored and stopped. When I done the export again with the
compress bit still errors at exactly at 2 gb.

I will tomorrow try making a file bigger then 2gb as an extra check but
I am 99% sure Solaris 5.6 32 bit version does not support them!

Cheers
Darren


-----Original Message-----
From: Nelipovich, Tony [mailto:[Email Address Removed]
Sent: 30 September 2002 19:13
To: LazyDBA.com Discussion
Subject: RE: Oracle 7.3.4 Big Exports on Solaris 5.6????


Darren -

Add a split command to the background process. Something like...

gzip $GzipFlags < $Named_pipe | split $SplitFlags ${ExpPath}/${Export} &

You used compress, but gzip is similar. This will split your gzip'd
output into bite size chunks as defined by $SplitFlags

...Tony Nelipovich

-----Original Message-----
From: Darren S. Eyers [mailto:[Email Address Removed] Monday, September 30, 2002 11:02 AM
To: LazyDBA.com Discussion
Subject: Oracle 7.3.4 Big Exports on Solaris 5.6????


Hi Gurus!

Have been unable to export a large database on Solaris 5.6 with the
export stream being compressed as it writes to the export file. Below
is a copy of the script I used from http://www.dbaoncall.net/:

#!/bin/ksh
rm -r /tmp/exp_fifo_file
mkfifo /tmp/exp_fifo_file
compress > $2 < /tmp/exp_fifo_file &
sleep 2
exp file=/tmp/exp_fifo_file parfile=$1

Any ideas what to do on Oracle 7.3.4 when this creates a file over the
2gb limit and dies? The only way round this is to export schemas, then
tables is that does not work with out all the over bits like triggers
and extract them separately, but what can you do if one table takes up
over 2gb of space compressed?

I guess use create table as into sub tables. Is there a better way on
this platform using Oracle 713. If only Oracle 8i!

Thanks
Darren


------------------------------------------------------------------------
------
This e-mail is intended for the use of the addressee(s) only and may
contain privileged, confidential, or proprietary information that is
exempt from disclosure under law. If you have received this message in
error, please inform us promptly by reply e-mail, then delete the e-mail
and destroy any printed copy. Thank you.

========================================================================
======

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page