Re: ORACLE-L Digest -- Volume 2000, Number 168

Henrik,

There are problems using synonyms in the snapshot subquery. Hard code the owner.table_name_at_db_link in the sub-query.

We ran into the following under Oracle 8.1.5, this results in an "ORA-12014: table 'TEST_1_RMT' does not contain a primary key constraint" error.

create snapshot test_1 as select * from test_1_rmt;

• test_1_rmt is a pulic synonym containing the owner, table and database link.

create snapshot test_1 as select * from owner.test_1_at_dblink;

Successfully creates the snapshot.

Bugs 841897/536953, fixed in 8.1.7 and 8.0.6.

HTH,
Dave Ryan.
Regina, Saskatchewan, Canada

henrik.ekenberg_at_4tsolutions.se on 06/16/2000 07:26:09 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Dave Ryan/ITC/SWP)

Subject: Re: ORACLE-L Digest -- Volume 2000, Number 168

Hello,

We are on NT /ORacle 8.04
And we try to build replication between 2 dbs.

I have a small problem....
When I create the snapshot I receive an error message that told me that the table doesn't have any primary key. But the table have a primary key and it is enabled....

Any suggestions ?

Regards
Henrik E.

--
Author:
  INET: henrik.ekenberg_at_4tsolutions.se

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).