| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Design problem; distributed DB
Create to separate Table with other names and concat them to the
application via views.
I've done this a few time ago and it works.
Thorsten Kubis wrote:
> Hello All!
>
> After successfull design of some multi-master-replications I have
> the following problem now. I have two DB´s on different locations.
> Database A should be called the master and my DB B is a subset of
> A.
> Now my problem: Table B1 (mine) has primary key from table A1 and
> some columns of A1. Also B1 should have some more columns that are
> not in A1. So B1 is a Mix of Columns from the Master table
> and my own columns.
>
> So full table replication or snapshots is not the solution.
> How can my table B1
> be updated with the data from table A1. Should I use
> procedureal replication or just triggers on the Master DB A tables
> that insert Data into my tables?
>
> Are there any suggestions on this forum or is there a simple
> solution I never heard about?
>
> regards
>
> Thorsten
--
 |
 |