Re: exact replica

mike7411_at_gmail.com wrote:
> Let's say you want to create a site that has an exact replica of
> another site, and it is to be continuously updated. What is the
> simplest way to do this?
>
> I have considered options involving materialized views. However, I
> want the table structure and names to be exactly the same on both
> sites. With materialized views, I don't see how this is possible.
> Any ideas?
>
> Thank you.

Please define "continuously." Dataguard can do it on log switches, and is the simplest.

What do you intend to use the replica for? Reporting? Failover? Disaster Recovery? Testing? Another place to input data?

You can also find white papers on Oracle's various options at oracle.com.
http://www.oracle.com/technology/deploy/availability/index.html

jg

--
@home.com is bogus.
"she is getting error message that say undliveriable messages,her hole
area cannot send externail emails" - Chronicles of George