I have built some reports at BI Publisher 126.96.36.199.0 in a Linux Box.
However, when try to export it to Excel file, the process starts to generate cache files and tmp files at my /tmp filesystem (it has only 3.9GB) and it reaches 100% of used space.
Looking into Bi Publisher documentation Configuring Server Properties - 11g Release 1 (11.1.1) I've found at section "188.8.131.52 Setting the System Temporary Directory" you can provide a new System Temporary Directory. After set it I've noticed that the .fo and some .tmp files with 1GB filesize are still being created at my /tmp filesystem.
Is there a way to redirect ALL these .fo and .tmp files to this newest system temporary directory ?