Home » Server Options » Replication » refreshing snapshot with unique index
refreshing snapshot with unique index [message #43271] Tue, 01 July 2003 01:23
Guy Rassabi
Messages: 10
Registered: February 2003
Junior Member

As DBA of Data WareHouse I'm obsessive user of snapshot... (-:

Recently I get errors while refreshing snapshot with unique index.

I'm using the Fast Refresh option with DB link and log between 2 Oracle server and the get the following errors:

ORA-12008: error in snapshot refresh path
ORA-00001: unique constraint (DW_PROD_D.SUBSCRIBER_FACT_PK) violated

Important to say:
1)The Complete Refresh option that was running after getting that error work just fine.
2)The same unique index exists on both objects, the master and the snapshot.
3)These errors raised on other unique index tables with the same configuration
4) The snapshot query is simple - select * from master_table>@dblink

Any ideas?


Previous Topic: Unable to create a materialized view...with fast refresh
Next Topic: Help on Materialized views
Goto Forum:

Current Time: Sat Sep 25 23:02:08 CDT 2021