SQL*Plus (MOSC)

MOSC Banner

sqlplus not able to spool file more than 4G

edited Dec 28, 2009 2:00PM in SQL*Plus (MOSC) 10 commentsAnswered
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center