Export from oracle 8.0.5

[rbiorn]

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.

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

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

Regards
Ragnar

[A. Clay Stephenson]

Hi:

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.

Clay

[Andreas D. Skjervold · Accepted solution]

Hi
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:
8.0.5.0 to 8.0.5.2 inclusive - Get the patch for Bug:872947


Andreas

[Alexander M. Ermes]

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.

RGds
Alexander M. Ermes

[rbiorn]

(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
Regards
Ragnar