Home » Server Options » Replication » snapshot using rowid
snapshot using rowid [message #74979] Thu, 04 January 2001 01:35 Go to next message
ajay
Messages: 45
Registered: December 2000
Member
i have got 2 problems

1)i am unable to create a snapshot based on primary key
even when the master table has a primary key(enabled)
i am gettin error ora-12014(pkey does not exist in master table)...i am only able to create rowid based snapshot..

2)and when i finally created snapshot based on rowid
i am unable to update that using FAST
i am able to update that using only "C" -Complete..?

when i am givin exec dbms_snapshot('local_valid','f');
i am gettin ora-12032 error(snapshotlog cannot use rowid column);:(

any help in this issue wld be really appreciated.

ajay.

----------------------------------------------------------------------
Re: snapshot using rowid [message #74990 is a reply to message #74979] Tue, 23 January 2001 07:39 Go to previous message
Eddie
Messages: 23
Registered: January 2001
Junior Member
Hi,

Are you sure that the primary key realy exists on the MASTER site table? Check if the according index is valid.

Best regards,
Eddie

----------------------------------------------------------------------
Previous Topic: Snapshot not updating problem ..?
Next Topic: Re: Replication Notes...
Goto Forum:
  


Current Time: Thu Mar 28 08:22:47 CDT 2024