我想从11g DB表复制到12C DB表和12C DB表复制到11g DB表。 [英] I want to copy from 11g DB table to 12C DB table and 12C DB table to 11g DB table.

问题描述

我有两个不同的数据库（11g和12C）表。两个不同的表有相同的数据



几天后，11g数据库表添加了一些不同的数据，12C数据库表也添加了一些不同的数据。





但我需要从11g DB表复制到12C DB表和12C DB表到11g DB表。



这个问题的查询是什么。



我尝试了什么：



我对此问题一无所知，请帮助我。

I have two different databases (11g & 12C) tables. Two different tables have same data

After some days 11g DB table added some different data and 12C DB table also added some different data.


But i need to copy from 11g DB Table to 12C DB Table and 12C DB Table to 11g DB Table.

What the query for this issue.

What I have tried:

I Don't know any thing about this issue, Please help me.

推荐答案

没有单一查询可以让你合并两个不同的数据库，特别是如果它们都分别添加数据：它将取决于数据库表本身，以及其他表中是否有任何依赖数据。它还将取决于您用作主键的数据类型：如果您使用自动递增整数，那么您将遇到一个很大的问题，因为ID会重复出现。合并表时还需要考虑删除和更新 - 这不是一个小问题，你可以去做这个并且它将被排序。



您需要做的第一件事是获得一个解决方案，删除其中一个数据库，以确保不必每周都这样做。

There is no "single query" which will allow you to "merge" two different databases, particularly if they have both had data added separately: it will depend on the database tables themselves, and if there is any dependant data in other tables. It will also depend on the datatypes you have used as a primary key: if you used auto incrementing integers, then you have a big problem as the ID's will have repeated. You also need to consider deletions and updates when you merge the tables - this isn't a trivial problem that you can just go "do this" and it'll be sorted.

The first thing you need to do though, is get a solution in place that removes one of the databases to make sure this doesn't have to be done every week.

这篇关于我想从11g DB表复制到12C DB表和12C DB表复制到11g DB表。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！