《oracle数据库同步交换的方法-我收集的常见（Oracle database synchronous exchange - I collect common）.doc》由会员分享，可在线阅读，更多相关《oracle数据库同步交换的方法-我收集的常见（Oracle database synchronous exchange - I collect common）.doc（15页珍藏版）》请在金锄头文库上搜索。
1、oracle数据库同步交换的方法-我收集的常见（Oracle database synchronous exchange method - I collect common）Scheme and implementation of Oracle data synchronization:Oracle two tables of data is synchronized to the materialized view of third party Oracle, to the materialized view add trigger linkage to the third party in
2、 the Oracle table, then we obtain the original Oracle data table data synchronization, and the data can be extendedIntroduction to Oracle EBS FNDLOAD tools 2011-08-07The usage of FNDLOAD is a data synchronization tool provided by FNDLOAD, and it is officially supported by Oracle. FNDLOAD downloads t
3、he relevant definitions to a text file for transit, and then to another instance. Pass through.Contributors: xiaxinyn | Download: 49 | 12 | on 17 PagesCache management tool Impletetion brief usage method 2011-05-24The automatic download time interval is in minutes, between 301440, which controls the
4、 automatic synchronization operation cycle of the client cache synchronization tool. 4. object index management tool (1) (2) said the object is already selected.Contributors: Scarecrow life | Download: 0 | 0 | on 4 pagesOracle GoldenGate database synchronization technology 2011-01-16Oracle GoldenGat
5、e database synchronization technology - Oracle Oracle GoldenGate database synchronization technology Oracle GoldenGate TDM is a software based data replication side.Scheme one: build DATA_LINK between two, and directly write new data to another database program two: use SQLPLUSs COPY command program
6、 three: use exp/imp tools, incremental export / bootScenario 1: create DATA_LINK between two, and write new data directly to another databaseScenario two: using the COPY command of SQLPLUSScenario three: incremental export / import using the exp/imp toolScenario four: building StandByDatabase on hos
7、t 2Scenario five: Advanced Replication options for useHow do you exchange data between two Oracle servers?Source: worry free template Author: network editing update time: 2010-08-09 18:10 Click: SecondScenario 1: build the DATA_LINK between two databases and write the new data directly to another da
8、tabaseScenario two: using the COPY command of SQL *PLUSScenario three: incremental export / import using the eXP/imp toolScenario four: building Stand By Database on host 2Scenario five: using advanced replication options for OracleThe connection table is defined in a SQL statement in the relationsh
9、ip between tables and related data retrieved from one or more tables, in connection with table between the tables can be divided into four types, respectively, equal connection, connection, connection and self ranging connection, the several typical examples to analyze four different connection mode
10、s of Oracle table:1. equal joinAn equal join condition can be established by means of columns with the same meaning in two tables.Only rows that appear on the join column and appear in the two tables are equal in the result of the query.Examples of staff information and the corresponding staff in th
11、e Department of information;SELECT * FROM EMP, DEPT;SELECT * FROM EMP, DEPTWHERE EMP.DEPTNO = DEPT.DEPTNO;REM shows employees who pay more than 2000 of their salaries and the names of their employees.2. external connectionsFor external connections, Oracle can be represented by (+), and 9i can use LE
12、FT/RIGHT/FULL OUTER JOIN. The following examples will be introduced. In addition to displaying information that matches equal join conditions, it also displays information that cannot match a table with equal join conditions.External connections are identified by (+).A) left condition (+) = right co
13、ndition;Represents not only the information that matches the equal join condition,It also shows that the table in the right condition cannot match the information about the equal join condition.This is also known as the join. Another way of saying is:SELECT. FROM Table 1 RIGHT OUTER JOIN Table 2 ON
14、connection conditionB) left condition = right condition (+);In addition to displaying the information that matches the equal join condition, it also shows that the table in the left condition can not match the information of the equal join condition.It is also called left outer connectionSELECT. FRO
15、M Table 1 LEFT OUTER JOIN Table 2 ON connection conditionExamples show staff information and corresponding department information- unable to show staff information without Department- unable to show departmental information without employees-SELECT * FROM EMP, DEPT WHERE EMP.DEPTNO = DEPT.DEPTNO;Do equal join directly:SELECT * FROM EMP JOIN DEPT ON EMP.DEPTNO = DEPT.DEPTNO;REM displays employee information and corresponding departmental information, showing departmental information without employees-SELECT * FROM EMP, DEPT WHERE EMP.DEPTNO (+) = DEPT.DEPTNO;SELE
