use the sequence created in the Oracle database in the ODI10.1.3.2.0 version.
SOURCE table: Usr_odi. Odi_sequence2
CREATE TABLE Odi_sequence2 (
sequence_type VARCHAR2 () not NULL, last_sequence number is not
null
);
Target table: Usr_target. Odi_ SEQUENCE1
CREATE TABLE Odi_sequence1 (
sequence_type VARCHAR2 () not NULL,
last_sequence number primary key
);
Sequence: Usr_target. Sequence_io_students
Create sequence sequence_io_stu
transaction sequence commit, reasonable checkpoint mechanism, and reliable data transmission mechanism, ensuring data integrity and reliability.
GlodenGateThe main concerns are:
1. To achieve data synchronization, you must install GoldenGate media on the source and target databases respectively. In some data integration environments, the source database may be restricted.
2. To support GoldenGate, you need to set parameters for the source database (for example, to enable archiving logs and t
ODI is a data integration solution designed to help users free themselves from the time it takes to store a large amount of information on a variety of platforms and applications within the enterprise to do more meaningful things.
Oracle says integrated software allows companies to easily Process Business Intelligence, data warehouses, primary data management, business activity monitoring, application porti
See blog http://blog.csdn.net/lzflydream/article/details/20570813That's what it says, but the gods say it's too high-end. I don't know how to solve 911:42000:java.sql.sqlexception:ora-00911:invalid characterKm with a semicolon, km each sentence does
technology that allows you to freely scale your server capacity to meet the flexibility of your enterprise architecture. In addition, RAC provides powerful reliability, recovery, error detection, and continuous operation support.
• GoldenGate-Database Synchronization expert
The GoldenGate option helps enterprise databases cope with heterogeneous complexity and heterogeneous challenges, and helps enterprises maintain superb real-time and continuous availability across heterogeneous environments.
Tags: ODI HadoopThis article describes how to combine ODI with Hadoop. Before doing so, make sure you have the ODI software installed and build a Hadoop environment, or you can refer to my other blog posts to build the environment.1. Create a Directory[[emailprotected] ~]# hdfs dfs -mkdir -p /user/oracle/odi_home[[emai
-default initialization parameters. C lgwr is writing the log serial number D log switching information E. Execute the ALTER statement F to create the tablespace and restore segment)
C: \ oracle \ product \ 10.2.0 \ admin \ orcl \ udump \ orcl_ora_2828.TRC User tracking File
C: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ SYSTEM01.DBF -- tablespace Data FileC: \ oracl
Simple CDC, the simplest CDC. Here, each CDC table change is captured independently, and there is no need to consider the consistency of data between tables that have primary foreign key reference relationships.1 Environment PreparationSOURCE table: Odi_src. DEPT Target table: Odi_tag. DEPT Configuration topology See the creation and configuration of the ODI studio topology (Oracle) Model Reverse engineerin
The procedure for invoking the JAR package Java method in ODI is as follows:1. Write Java code as followsImportJava.io.File;ImportJava.io.FileOutputStream;ImportJava.io.OutputStream; Public classFileWriter { Public Static voidWriteFile ()throwsException {//1. Find a fileFile File=NewFile ("D:" + File.separator + "Temp.txt");//2. Instantiating OutputStream objectsOutputStream out=Newfileoutputstream (file); String Info= "Hello world!!!";//the string to
Tags: password log comm environment variable ROC RAC custom export TestBefore you use ODI, you must create a repository. The creation process is as follows:1. Environment variable Setting2. Using RCURCU is a usage program that creates a repository.[emailprotected]:~$ $ODI_HOME/oracle_common/bin/rcuDefault entry, Next:Select the database type and enter the connection information (the user name here must have DBA authority because Tablespace is created
Oracle
[Oracle] History of the Oracle ――oracle company legend
Author: fenng
Date: Sep 09 2004
The origins of Oracle Company
It is hard to imagine the Oracle Company's saga starting with IBM.
1970 June, IBM researcher Edgar Caut
Tags: http io ar using SP for on file dataThe problem to the machine environment:Oracle 11gR2 64bitNavicat for Oracle 11.0.10According to the practices of some of the great gods on the internet and some of the personal speculations, the following are summarized:The problem occurs because the navicat is inconsistent with the number of bits of Oracle, the former 32bit, the latter 64bitSome of the online pract
Resume oracle.sh in/etc/profile.d/
The contents are as follows in Nls_lang setup encoding
1 oracle_home=/usr/lib/oracle/12.1/client642 c_include_path=/usr/include/ oracle/12.1/client643 ld_library_path= $ORACLE _home/lib4# RememberThis was the client Nls_lang not the server one5 nls_lang=6 Export Oracle_ho ME Ld_library_path Nls_lang
Then modify the/ETC/INIT.D
, starting at m and intercepting N characters consecutively.---need to note: The database subscript is starting from 1!!!---n is truncated to the end of the current string if the number that is not specified or specified exceeds the actual character length that can be intercepted. n is the length.---if M is negative, it is intercepted from the countdown position. The number at the end cannot be negative.SELECT SUBSTR (' thinking in from dual;--->inSELECT SUBSTR (' thinking in from dual;--->in---
In our project, we encountered the problem of getting data from the databases of other systems for statistical analysis. We initially chose to use ORACLE's ODI tool for data extraction, but the database provided by the other party
In our project, we encountered the problem of getting data from the databases of other systems for statistical analysis. We initially chose to use ORACLE's ODI tool for data extra
Oracle BASICS (9) Oracle architecture and oracle infrastructure
1. Oracle Architecture Overview:
Oracle architecture refers to the composition, working process and principle of the database, as well as the organization and management mechanism of data in the database. To und
Oracle 10g AND Oracle 11g manual database creation case -- Oracle 11g
System Environment:
Operating System: RedHat EL6
Oracle: Oracle 10g and Oracle 11g
Manual database creation is relatively easy to implement. In this case, we
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.