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|
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29990276/viewspace-2929741/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- chrony /ˈkrɑːni/ vs ntpd 的核心区别
- LightDB新特性-Oracle模式支持回收站功能
- centos stream 8
- benchmarksql 压测MySQL报Every derived table must have its own alias解决
- LightDB-A gpfdist 命令初体验
- 数据库的sort group by和hash group by
- PostgreSQL citus常见报错问题分析（二）DETAIL: Distributed relations cannot have
- 事务可见性的判断和事务隔离级别，PostgreSQL和MySQL实现上有啥区别
- LightDB Canopy 常见报错问题分析（一）
- LightDB/postgresql内置特性之访问oracle之oracle_fdw介绍
