Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
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}<<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