| snapshot using rowid [message #74979] |
Thu, 04 January 2001 01:35  |
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  |
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
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
