审计

来源：互联网发布：淘宝店铺平台收费标准编辑：程序博客网时间：2024/05/16 00:56

MySQL:

select * from actor into outfile'/export/acotr.txt' fields terminated by '<[!]>' linesterminated 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.oinstallociuldr
chmod 775 ociuldr

3.示例：
su - oracle
ociuldr user=scott/tiger@orcl query="select * from scott.emp"field='<[!]>' record='<[end]>' file=/u01/emp.txttable=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.txttable=scott.emp batch=3

SqlSERVER:

库名表名导入路径
bcpOracle20141022.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"

0 0