0 Replies Latest reply on Jan 15, 2019 1:54 PM by f5f2b713-4df3-46b9-88e0-40f301f4e729

    Oracle Spooling Issues in Unix - 2GB file size limitation

    f5f2b713-4df3-46b9-88e0-40f301f4e729

      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}<<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