On January 27th, this site will be read-only as we migrate to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,650 Users
  • 2,269,771 Discussions
  • 7,916,809 Comments

Discussions

Oracle Spooling Issues in Unix - 2GB file size limitation

f5f2b713-4df3-46b9-88e0-40f301f4e729
edited Jan 15, 2019 9:00AM in Developer Solutions

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