In the subsidiary company of a deployed oralce database, now need to merge the data for each subsidiary to a database instance deployed to a group of companies, all subsidiaries of the oracle database data table space, users, data structure is consistent, to ask what is the good way? Thank you very much!

CodePudding user response:

Table data to more heavy, the union directly

CodePudding user response:

The more troublesome, you have subsidiary coding table? If not, the new table inside distinguish subsidiary?
Suggestions put repository, structure design, data migration is only a matter of time

CodePudding user response:

refer to the second floor yaiger response:

the more troublesome, you have subsidiary coding table? If not, the new table inside distinguish subsidiary?
Suggestions put repository, structure design, data migration is only a matter of time

I just want to simply remove the key table together repeatedly, do not have this code

CodePudding user response:

Could you direct access to the subsidiary of the oracle database?
If you can't access, first built in corporation, a subsidiary of database users, firing a company's data inside

CodePudding user response:

And then build a user from the head office, firing a company's data with the union merge into head office table,
But there are some problems inside the
Such as basic data, such as the user, name, etc., if exactly the same, will go to heavy
But business data, the biggest problem is that ID is possible, and the same ID are not necessarily the same transaction,
So proposal ID of each branch are slightly changed, coupled with a logo, so we can together,

CodePudding user response:

Feeling is not very suggestion with the union, if data is larger

CodePudding user response:

If such data is the data dictionary, can the union, if it is a business data, the union was not in the past, you can add "unit number" union all can consider,