Re: Replication Problem Solaris/Oracle7.3.4 HPUX10.20 8.0.5.1

Helen

Have you created Snapshot Logs on all Master Site Tables?

If you are using FAST REFRESH mode, as opposed to COMPLETE Refresh mode, you will need to create SNAPSHOT LOGS on all Master Site tables first, BEFORE you create any Snapshots on tables.

Also you may want to assign all related snapshots to a REFRESH GROUP, to help synchronise your replication for a related group of tables for referential integrity, transaction consistency etc., and when setting up Refresh Intervals for AUTOMATIC Refreshes.

For further info - read Chapter 2 Using Basic Replication in Replication book of Online Oracle8 Documentation Library.

I have just started on Replication too, and it is definitely challeging and non-trivial for complex multi-master, multi-site environments etc..

HTH Joe
Oracle, Business Intelligence and Data Warehousing specialist

PS Are you in Australia? Where?
Helen Macduff wrote in message <380C0B41.E4A7E93D_at_alcatel.com.au>...
>I cant create simple snapshots on a particular production database.
>Works fine in devel and test for the same operation systems and
>database version.
>The patch levels are the same.
>
>The statement create snapshot 'name' refresh fast with rowid as
>'select stmt' fails
>
>as does create snapshot 'name' refresh with rowid as 'select'
>
>however create snapshot 'name' refresh with rowid as 'select'
>where rownum < 40000 works (there are only 36000 rows in the table)
>as does create view as 'select'
Received on Tue Oct 19 1999 - 10:33:32 CDT