审计

MySQL:

select * from actor into outfile '/export/acotr.txt' fields terminated by '<[!]>' lines terminated by '<[end]>';

mysqldump -uroot -p -S /export/servers/mysql/tmp/mysql.sock -T /export sakila actor --fields-terminated-by '<[!]>' --lines-terminated-by '<[end]>';

ORACLE:

1.将ociuldr配置文件上传到BIN目录下

2.chown oracle.oinstall ociuldr
chmod 775 ociuldr

3.示例：
su - oracle
ociuldr user=scott/tiger@orcl query="select * from scott.emp" field='<[!]>' record='<[end]>' file=/u01/emp.txt table=scott.emp

4.用batch将数据文件生成多个文件，默认一个batch是50W数据量，指定file选项来定义生成的文件名, 中间请包含"%b“字样, 在生成文件时, ”%b“会被打印成序号
ociuldr user=scott/tiger@orcl query="select * from scott.emp" field='<[!]>' record='<[end]>' file=/u01/emp_%b.txt table=scott.emp batch=3

SqlSERVER:

库名 表名 导入路径
bcp Oracle20141022.dbo.iou_receipt_1028 in "D:\oracle_data\shenji_data1022\5.csv" -T -t"<[!]>" -r"<[end]>" -c -b 5000 -e "D:\oracle_data\shenji_data1022\log\iou_receipt_1028.log" -o "D:\oracle_data\shenji_data1022\log\iou_receipt_1028.logd"

导出日志 报错日志
远程：
-S 172.17.29.127 -U sa -P "abc123456"