LightDB 22.4 新特性之兼容Oracle sqluldr2

oracle数据导出工具sqluldr2可以将数据以csv、txt等格式导出，适用于大批量数据的导出，导出速度非常快。导出后可以使用oracle loader工具将数据导入。从22.4 LightDB支持此功能

[lightdb@node1 ~]$ ltuldr user=lightdb password=lightdb123 dbname=test host=127.0.0.1 port=5432 query='select * from emp2' field='|' file=/home/lightdb/test.csv
       0 rows exported at 2022-12-27 17:27:29
      14 rows exported at 2022-12-27 17:27:29
         output file /home/lightdb/test.csv closed at 14 rows.

查看导出文件内容

[lightdb@node1 ~]$ cat test.csv 
7369|SMITH|CLERK|7902|1980-12-17|800.00||20|
7499|ALLEN|SALESMAN|7698|1981-02-20|1600.00|300.00|30|
7521|WARD|SALESMAN|7698|1981-02-22|1250.00|500.00|30|
7566|JONES|MANAGER|7839|1981-04-02|2975.00||20|
7654|MARTIN|SALESMAN|7698|1981-09-28|1250.00|1400.00|30|
7698|BLAKE|MANAGER|7839|1981-05-01|2850.00||30|
7782|CLARK|MANAGER|7839|1981-06-09|2450.00||10|
7839|KING|PRESIDENT||1981-11-17|5000.00||10|
7844|TURNER|SALESMAN|7698|1981-09-08|1500.00|0.00|30|
7900|JAMES|CLERK|7698|1981-12-03|950.00||30|
7902|FORD|ANALYST|7566|1981-12-03|3000.00||20|
7934|MILLER|CLERK|7782|1982-01-23|1300.00||10|
7788|SCOTT|ANALYST|7566|1987-04-19|3000.00||20|
7876|ADAMS|CLERK|7788|1987-05-23|1100.00||20|