Re: Multimaster replication confusion!

julius.cooper_at_gmail.com wrote:
> Hello all,
>
> Okay, so here's my dilemma:
>
> I have 5 databases--let's call them A, B, C, D, and E--that have
> distinct data (schemaA, schemaB...). I am trying to "consolidate" all
> of my data into a new, single database, F, and then propogate THAT data
> (F.schemaA, F.schemaB...) out to 10 or 15 workstations, so that each
> has a local copy of the data the other applications (Databases A-E) are
> affecting.

If I may interrupt for a second ... why? Why replicate to workstations? This is a horrible security and audit issue and what does it get you? Why can't these users work inside the database where they belong?

> So, what I did was:
>
> I created database F, and rolled up the schema from the original five
> servers (F.schemaF) onto it. Now, for my test environment, I wanted to
> have each of the first five servers, as well as the new, sixth server,
> able to share all of that data. But, when I tried to set-up
> Multi-master Replication (via Enterprise Manager), I was only able to
> push the schema (F.schemaF) from my "Master Site" (F) to the other five
> databases.

And the Oracle version is? Because if 9i or 10g you should be thinking a very different technology. It is important to know the version before answering.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)