Showing results for 
Search instead for 
Did you mean: 

Export from oracle 8.0.5

Go to solution

Export from oracle 8.0.5

Platform is HP_UX 10.20
Filsystem is created and mounted with option 'largefiles'.
# fsadm -F vxfs / returns largefiles.
I have tested with both 'dd' and 'prealloc' commands to generate a file > 2Gb. This behaves OK.

The database export always stops at 2Gb with errormessage 'Error writing to exportfile'.

Why is this happening?
Is there a parameter in the oracle 'exp' command to allow exportfile larger then 2Gb?

"You cannot achieve anything beyond your wildest dreams --- if you don't have any wild dreams"
A. Clay Stephenson
Acclaimed Contributor

Re: Export from oracle 8.0.5


I had a problem very similar to this:

1) Check ulimit - I don't think that is it.
2) I actually had the problem in the import but the solution is the same - use a named pipe.

From another terminal session do this:
mknod /tmp/exportpipe p
dd if=/tmp/exportpipe of=/xxx/myexport.exp

You then export to /tmp/exportpipe rather than a file and all is well.

You may have to use a named pipe for the import as well but that works too - just reverse the arguments to dd.

If it ain't broke, I can fix that.
Andreas D. Skjervold
Honored Contributor

Re: Export from oracle 8.0.5

Oracle export should be able to generate 2>GB files on 8.0.5, but if HP-UX 10.20, a patch is required:
From Metalink:
HPUX 10.20 requires a patch to create >2Gb export files: to inclusive - Get the patch for Bug:872947

Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
Alexander M. Ermes
Honored Contributor

Re: Export from oracle 8.0.5

Hi there.
You also can go this way :

mkfifo /dir/gzip_pipe
cat /dir/gzip_pipe | gzip > /dir/export.dmp.gz

exp user/password parfile=xy.parfile file=/dir/gzip_pipe

That will zip your file immediately.

Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"

Re: Export from oracle 8.0.5

(Takk skal du ha Andreas!)
Thank you Andreas!
Although I have not had time to test this yet, I'am sure it will work. Your answer has been verified by HP-Netherlands (Thank you Wil).

Thank you also to Clay and Alexander. I'am sure your workarounds work, but I'am not going to try then since there is a oracle patch to fix it.

Thanks again
"You cannot achieve anything beyond your wildest dreams --- if you don't have any wild dreams"