OraFAQ Forum: Server Administration » refreshing snapshot with unique index

Home » RDBMS Server » Server Administration » refreshing snapshot with unique index

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

refreshing snapshot with unique index [message #57690]

Tue, 01 July 2003 01:22

Guy Rassabi
Messages: 10
Registered: February 2003

Junior Member

Hi,

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?

Thank

Guy

Report message to a moderator

Previous Topic:	Clarify my doubts!!
Next Topic:	undo TS moving to Pending Switch-Out state

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:27:05 CDT 2024