Re: pros and cons

From: <jo_holvoet_at_amis.com>
Date: Thu, 01 Apr 2004 09:49:50 +0200
Message-id: <OFBCD7BD6A.F1968C20-ONC1256E69.002A8760@eu.amis.com>

In the good old days of 8.0, this was a problem for advanced replication : the table you wanted to replicate had to have a PK and it had to be enforced by a unique index (the error message we got when this was not the case was "table or view does not exist" : very helpful in tracking down the problem :).
If you are planning to use replication, you might want to check the current requirements for the PK index.

mvg/regards

Sai Selvaganesan <ssaisundar_at_sbcglobal.net> Sent by: oracle-l-bounce_at_freelists.org
03/31/2004 00:50
Please respond to oracle-l

        To:     oracle-l_at_freelists.org
        cc: 
        Subject:        pros and cons

i read the follwing line in oracle 9i documentation,

Unique and primary keys can use non-unique as well as unique indexes. They can even use just the first few columns of non-unique indexes.

i am planning to use a primary key constraint enforced by the first few columns of a non-unique index.any feedback or advice or gotchas in having such a setup.

thanks
sai

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Thu Apr 01 2004 - 01:46:16 CST