Having to refresh every hour, you would not be likely to use export/import.
Snapshots are a probable solution but you have to answer D Morgan's last
three questions to be sure. The answer to your two snapshot questions are
no and yes. Go to the Oracle documentation and read about snapshots before
you start.
"DA Morgan" <damorgan_at_exesolutions.com> wrote in message
news:3E6BA621.6934B4DD_at_exesolutions.com...
> 76434.1353_at_compuserve.com wrote:
>
> > I have to replicate the same table "A" from 5 different servers to a
> > central server 6 . In short replicate 5x table "A" to 5x seperate
> > tables "A " on server 6.
> >
> > What is the best option to approach this?
> >
> > -Export - Import is not efficient (besides that I need to refresh the
> > central tables o server 6 every hour)
> >
> > - I was thinking about creating a snapshot from the 5 server to
> > central server 6 or has somebody a better idea for me?
> >
> > Questions about Snapshots.
> > Has the schema owner on the master server to be same schema owner on
> > the target server?
> > - Table A has the same name ("A") in every server. Can the snapshot
> > send data to a different table name on the target server? I need 5
> > separete tables in the target (central) server.
> >
> > Thanks
> >
> >
> >
>
> How often?
> How close to real time?
> How much data?
> How mission critical?
>
> Daniel Morgan
>
Received on Sun Mar 09 2003 - 17:10:22 CST
