Skip to Main Content

Cloud Platform

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

Oracle Spooling Issues in Unix - 2GB file size limitation

f5f2b713-4df3-46b9-88e0-40f301f4e729Jan 15 2019 — edited Jan 15 2019

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

Comments
Post Details
Added on Jan 15 2019
0 comments
1,626 views