|
-
found this note in metalink
symptom: ORA-12014: table '%s' does not contain a primary key constraint
symptom: Database link has been created correctly
cause: If the snapshot definition query of a CREATE SNAPSHOT DDL
referenced a remote table, whose owner is not explicitly
specified, an ORA-12014 was raised if the owner of the
snapshot was different than the username specified in the
database link that was used to access the remote table.
The error is VERY misleading. The table you are creating a snapshot
from does have a primary key constraint and your snapshot log is recording
WITH PRIMARY KEY.
siva prakash
DBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|