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|