oracle导出千万级数据为csv格式 sqluldr2 - dataexport.bin

cp dataexport.bin $ORACLE_HOME/bin
cd $ORACLE_HOME/bin
chmod +x dataexport.bin

export data: 表名前加schema
vi /tmp/20221024/query.sql
select * from scott.test;

--head=yes: 打印出行数

dataexport.bin sys sql=/tmp/20221024/query.sql head=yes file=/tmp/20221024/query.csv

--按记录数切分
dataexport.bin sys sql=/tmp/20221024/query.sql rows=1000000 batch=yes file=/tmp/20221024/query.%b.csv

--按文件大小切分
dataexport.bin sys sql=/tmp/20221024/query.sql size=100MB batch=yes file=/tmp/20221024/query2.%b.csv

常见错误:
1. error while loading shared libraries: libXXXXXXX.so.1: cannot open shared object file: No such file or directory
设置oracle的环境变量加载oracle的lib包
cd /home/oracle
vi .bash_profile
export LD_LIBRARY_PATH=$ORACLE_HOME/bin:$ORACLE_HOME/lib:/lib:/usr/lib

2.ora-24345: A Truncation or null fetch error occurred
https://blog.csdn.net/qq_39255840/article/details/82740707

导出参数加上safe=yes