把从Oracle数据库导出的数据导入到MySql数据库中
1. 使用默认的结束符号导入到MySql数据库中:
LOAD DATA LOCAL INFILE 'd:\oracle.txt' IGNORE INTO TABLE alarmLog |
此时Fields的结束符默认的就是'\t'制表符,而不是"\t"字符串.
2. 当设定Fields结束符导入到MySql数据库中:
LOAD DATA LOCAL INFILE 'd:\oraclea.txt' IGNORE INTO TABLE alarmLog FIELDS TERMINATED BY '~' |
以上两种情况使用的数据文件oracle.txt和oraclea.txt都是通过ociuldr.exe程序导出.
把从MySql导出的数据导入到oracle数据库中
1. 通过设定Fields结束符把MySql数据库中的数据导入到文件
select * from alarmLog into outfile 'd:\mysql.txt' FIELDS TERMINATED BY '~' |
通过sqlldr把d:\mysql.txt数据文件导入到oracle数据库中.注意控制文件的书写,下面是测试程序对应的控制文件.
OPTIONS(BINDSIZE=8388608,READSIZE=8388608,ERRORS=-1,ROWS=50000) LOAD DATA INFILE 'd:\mysql.txt' "STR X'0A'" INTO TABLE instantdata FIELDS TERMINATED BY '~' TRAILING NULLCOLS ( FIELDID CHAR(20), CreateTIME date 'yyyy-mm-dd hh24:mi:ss', AckTIME date 'yyyy-mm-dd hh24:mi:ss', TYPE CHAR(40), QUALITY CHAR(40), VALUE CHAR(40), AVG CHAR(40), MAX CHAR(40), MIN CHAR(40), SUM CHAR(40) )
|
分享到:
相关推荐
Permission is granted to make and distribute verbatim copies of this manual provided the copyright notice and this permission notice are preserved on all copies. Permission is granted to copy and ...
import/export截图
SMS-Tools, 用于 Android/iOS/GV 文本消息历史记录的Import/Export/Merge 工具 短信工具用于文本消息历史记录的多用途 import/export/merge 工具。 ( 正式的Android-SMS-DB-importer )现在在 PyPi ( 。python 软件包...
AWS官方文档:CloudFront Glacier ImportExport S3 StorageGateway
SqlLite/Mysql/Oracle数据库基于pycharm连接、增删改查基本操作python使用全 # 1连接数据库 2 拿到游标 3 执行sql 4关闭游标 5关闭数据库 import _sqlite3 # 连接 conn = _sqlite3.connect('test.db') #拿到游标 ...
Calendar Import/Export This app allows you to import/export your calendars using ics files without using Google synchronization services. For more information, see ...
泛微OA9前台任意文件上传漏洞位于: /page/exportImport/uploadOperation.jsp文件中Jsp流程大概是:判断请求是否是mult
R Data Import/Export describes the import and export facilities available either in R itself or via packages which are available from CRAN.
Resource file and Excel file import and export Resource file and Excel file import and export Resource file and Excel file import and export
solr-import-export-json最新代码solr-import-export-json最新代码solr-import-export-json最新代码solr-import-export-json最新代码solr-import-export-json最新代码solr-import-export-json最新代码solr-import-...
官方资料:白皮书[英文]Oracle Database 12c: Full Transportable Export/Import Full Transportable Export/lmport Support for Pluggable Databases ;Internals of Full Transportable Export/lmport;Full ...
It can connect users to local/remote server, providing several utilities such as Data Modeling Tool, Data/Structure Synchronization, Import/Export, Backup/restore and Report to facilitate the process...
搬移Oracle資料庫所用之Export. Import方法
pmd_import_export_v04-mk64n
EMS Advanced Data Import/Export 是100% Delphi开发的数据导入、导出控件集,适用于Borland Delphi 、C++ Builder 开发环境。 支持 MS Excel, MS Access, DBF, XML, TXT, CSV, ODF, and HTML 等格式文件导入导出。 ...
MusicXML import/Export 和 MIDI (SMF) import/export。MuseData导入,用于音符输入的MIDI输入,带有集成的音序器和软件合成器来播放乐谱。您可以打印或创建 pdf 文件。MuseScore 提供了许多学习资源来帮助新用户...
- other_import/nacos_config_export_user.zip:user导入文件 - other_import/nacos_config_export_goods.zip:goods导入文件 - other_import/nacos_config_export_inventory.zip:inventory导入文件 - other_import...
- other_import/nacos_config_export_user.zip:user导入文件 - other_import/nacos_config_export_goods.zip:goods导入文件 - other_import/nacos_config_export_inventory.zip:inventory导入文件 - other_...
MySQL Sybase ASE Import, Export & Convert Software,数库互相转换,导入工具。
Gain skills in MySQL’s fundamental features, including supported data types, database management syntax, triggers, views, stored routine syntax, and import/export capabilities Work with hundreds of...