How to import data into DB2 orcale

2010-12-30  来源:本站原创  分类:Database  人气:133 

Sometimes the reason is because we need to project such a database from the oracle data to DB2, caused us great trouble, busy all day yesterday, found a good tool, easy and simple but also can support the data together into . Said DB29.7 have a better tool than, that I did not try. I am using IBM's MTK, MTK Here is more information and download:
http://www.ibm.com/developerworks/cn/ondemand/migrate/db.html
MTK above description as well as support for various data and documents, but in English, but that's okay, you can download the tool operating in accordance with the following URL
http://www.ibm.com/developerworks/cn/data/library/techarticles/dm-0411yip/ # author1
Note: In the last step when the options can be put into check on the data can be achieved;
Possible problems: I am from oracle10i-"db2V8, db2's odbc there will be automatically configured for you, but oracle does not need you to manually configure, or in the last step will prompt you the steps ODBC error message: Control Panel - "Administrative Tools -" data source - the "User DSN, add a for oracle, and said that if the need is win7 System DSN, then add;
After installation you can run the directory specified in the report to view the file, which will introduce the state;

I had -668 error after import, the following is the solution:
Solution: SET INTEGRITY FOR table IMMEDIATE CHECKED
To execute this command if the error is resolved not to change the IMMEDIATE CHECKED IMMEDIATE UNCHECKE
Example: SET INTEGRITY FOR SCHEMA.TABLE IMMEDIATE CHECKED
Successful, will save the data or if you have the original data oracle, if you still get it working you can try the following trick:
db2 "load from empty.ixf of ixf terminate into table"
I tried, after the implementation of the query but the data can be lost,
Online friends are also using: reorg table XXX.TABLE, we can try next.

MTK can actually start on the user - "All programs -" mtk start can also start their own command, as follows
1. Set path =% path%; C: \ Program Files \ IBM \ SQLLIB \ java \ jdk \ bin
2. Cd c: \ mtk
3. MTKMain.bat-mtk

相关文章
  • How to import data to DB2 orcale 2010-12-30

    Sometimes the reason for the project so we need the database from the oracle data to DB2, causing great trouble to us, a busy day yesterday, found a good tool, easy and simple but also can support the data together into . DB29.7 said there will be a

  • How to import data into DB2 orcale 2010-12-30

    Sometimes the reason is because we need to project such a database from the oracle data to DB2, caused us great trouble, busy all day yesterday, found a good tool, easy and simple but also can support the data together into . Said DB29.7 have a bette

  • How to import data from MS Office Excel to SQL Server 2005 2010-03-17

    1 Excel 2003 to Ms2005 A start I use Ms2005 clients into remote Ms2005 database, the excel file into SQL problems error: After using Import Wizard: The process of implementation error: Error 0xc00470fe: Data Flow Task: The product level is insufficie

  • Import data in SQL SERVER 2005, but the tips can not establish a data flow connection 2010-05-08

    Import data in SQL SERVER 2005, but the tips can not establish a data flow connection: Error message as follows: Can not establish a data stream connection. For the connection manager "(3C8CD7CF-E647-41F8-A2A4-1069B64F0156)" specifies the connec

  • sql server 2008 to connect Oracle 10g do import data error oraoledbpus10.dll: Can not find the specified module 2010-05-27

    sql server 2008 oracle 10g import data from connected data source selection when the oracle provider fro OLE DB connection when reporting oraoledbpus10.dll: can not find the specified module Solution: OraOLEDBpus10.dll copying it into system32, but i

  • orcle import data file 2010-06-21

    Bj has to work in 2 months, and feeling into the state has not only forced himself into. In order not to neglect the things learned before the planned start to understand from the database. Then made a copy from somewhere 3.xG database files, restore

  • Bulk import data (insert) 2010-06-22

    Since import data is the number of insert will occupy a lot of cpu, and slow. The following is the write data to a number of insert statements into the method. Modeled insert into select statement, the number of records through the select from dual a

  • Import data to Mysql from dump file 2010-08-01

    Import the backup database file to Mysql, use below command. 1.use cmd command to locate the mysql bin directory: eg, C: \ Program Files \ MySQL \ bin 2. Use the command to import data to database: mysql-uroot-p123 sfproject <d: \ php \ maxtor_bak1 N

  • Oracle imp import data specified table space 2010-08-04

    imp import data specified table space, roughly the following ways: 1. There is a simple way to apply to relatively few cases of data: direct use UltraEdit to fight side DMP file, the default is 16 hexadecimal, switch to text mode, the inside: TABLESP

  • oracle installation steps to import data 2010-08-04

    1. Install Oracle 10g, the installation process takes note of the last steps to select lock which users , Remove the check in front of the sys . 2. At the command line used to sys sysdba Login to oracle roles, command :sqlplus sys/sys as sysdba, The

  • (Transfer) to import data into Oracle General There are several ways! The voice of experience, but oh! 2010-08-31

    http://hi.baidu.com/will0690/blog/item/7ea2203f79f404ec55e723fa.html General import data into Oracle There are several ways! This voice of experience, but oh! 2006-12-27 20:00 Engage in the next few days ago, will excel sheet into oracle database pro

  • load data infile mysql import data usage 2010-09-01

    We often import the data! mysql import an efficient way, that is, load data infile look at the following case illustrates Basic syntax: load data [low_priority] [local] infile 'file_name txt' [replace | ignore] into table tbl_name [Fields [Terminated

  • oracle export import data 2010-09-07

    Export Data exp gpsuser / cistjava @ 192.168.1.72/arcgis Import Data imp gpsuser / cistjava @ 192.168.1.72/arcgis

  • Method of SQL Server to export import data 2010-09-10

    First, export the database into a SQL Server in 1. In SQL Server Enterprise Manager in the database to be transferred is selected, press the mouse button, select All Tasks -> Backup Database. 2. Select the database backup - full, Purpose of the backu

  • MySQL command to export import data 2010-09-18

    Keywords: mysql command to export import data 1. Export the entire database mysqldump-u username-p database name> exported file name mysqldump-u wcnc-p smgp_apps_wcnc> wcnc.sql 2. Exporting a table mysqldump-u username-p database watches were> ex

  • oracle import data from one tablespace to another tablespace 2010-09-18

    Question: In the use exp to export user data, then use imp to import, you must ensure consistency between the two objects can be successfully imported tablespace This share point solution: exp export user data: exp userid = user / user owner = user f

  • oracle imp to import data to another tablespace 2010-09-19

    oracle imp to import data to another tablespace Many people during data migration, we hope to import the data into the table space is different from the original system, are often found after import, the data is imported the original table space. Thi

  • PL / SQL to import data (cvs and excel) 2010-09-27

    PL / SQL supports multiple formats of data import, excel here and explain the format of cvs import. 1, cvs import format 1) into the PL / SQL, select: Tools -> text importing device -> the data from text file, then the top left corner of the "O

  • How to write a batch file to automatically import data into oracle database 2010-10-02

    Oracle Database automatically import and export, in many places there is a wide range of applications. For example: an Oracle database application system development after the end of the system if you want to install to the client computer, you need

  • oracle imp import data abort 2010-12-13

    oracle imp import data fail in the middle, the beginning of the show into a successful, but there have been two seconds