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.

Not sure what the naming has to do with it. But does your Oracle have a version?

Consider:
Hand coding via a db link
Advanced Replication
Streams
Data Guard

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org