sqlplus not able to spool file more than 4G
We are running a sql script from sqlplus which is producing an output file
larger than 2 GB, but the spool file stops before completion.
Note: we can create a file of 4Go in this FS.
Our OS administrator confirms us that there are no OS limits for the file size and we can create a file with a size as we want.
But when we run a query from sqlplus with a spool file the output file stoped with a size of 2 GB, and the query continue to be executed successfully.
-rw-r--r-- 1 oracle dba 2147483647 Oct 13 14:54 order_01.lst
Need your quick help plz.
Note: we can create a file of 4Go in this FS.
Our OS administrator confirms us that there are no OS limits for the file size and we can create a file with a size as we want.
But when we run a query from sqlplus with a spool file the output file stoped with a size of 2 GB, and the query continue to be executed successfully.
-rw-r--r-- 1 oracle dba 2147483647 Oct 13 14:54 order_01.lst
Need your quick help plz.
0