Materialized Views

From: Lindsay Stoddard <lindsay.stoddard_at_osha-slc.gov>
Date: Tue, 28 Aug 2001 06:47:58 -0700
Message-ID: <F001.0037971C.20010828055046@fatcity.com>

Hi List,

I am having trouble replicating a schema onto another database. I have looked at the Oracle documentation and am having a hard time deciding which steps to take in accomplishing this task. The schema includes tables indexes, packages, and triggers.

I have had success in creating a materialized view but am unsure how it all works with regards to including indexes, packages, and triggers and creating materialized groups.

I was wondering if anyone has any simple examples of doing this (replication of a whole schema) or if there are any white papers out there which can explain this better than the Oracle documentation on Replication?

Thanks,

Lindsay Stoddard

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Lindsay Stoddard
  INET: lindsay.stoddard_at_osha-slc.gov

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Aug 28 2001 - 08:47:58 CDT