Forum Stats

  • 3,733,507 Users
  • 2,246,777 Discussions
  • 7,856,742 Comments

Discussions

Oracle Spooling Issues in Unix - 2GB file size limitation

Hi All,

I was running a shell script to extract data from Oracle database into unix server location.

The unix location has been assigned to a mount point which has 10 TB space. The extracted file size is 16GB.

I am using below command to spool-

`sqlplus -s ${USER_NAME}/${password}@${server}&lt;<EOF

                spool abc.csv

                set colsep '\",\"'

                set verify off;

                set pagesize 0;

                set linesize 32767;

                set trimspool on;

                set feedback off;

                @Data/col_list.sql;

                spool off

EOF`

col_list contains sql query as below -

SELECT

COL_1||','||

'"'||COL_2||'"'||','||

COL_3||','||

COL_4||','||

'"'||COL_5||'"'||','||

COL_6||','||

COL_7||','||

'"'||COL_8||'"'||','||

'"'||COL_9||'"'||','||

'"'||COL_10||'"'||','||

'"'||COL_11||'"'||','||

COL_12||','||

COL_13||','||

COL_14||','||

'"'||COL_15||'"'||','||

'"'||COL_16||'"'||','||

'"'||COL_17||'"'||','||

'"'||COL_18||'"'||','||

'"'||COL_19||'"'||','||

COL_20||','||

'"'||COL_21||'"'||','||

COL_22||','||

COL_23||','||

COL_24||','||

COL_25||','||

COL_26||','||

COL_27||','||

'"'||COL_28||'"'||','||

'"'||COL_29||'"'||','||

COL_30

FROM ABC;

Problem -

After extracting 2GB of data into abc.csv file, the file size is not getting increased. I have tried with multiple tables. Same issues is occurred in all the cases.

It is happening for all the tables which have more data than 2GB.

Could you please suggest me how to handle this situation? Any quick solution.

Thanks,

Mukesh Paul

Sign In or Register to comment.