replication and primary key

several years ago , I implemented the oracle replication system.

At that time our database was ported from an old Fox pro application. ( K , no laughing at the back).

As the foxpro did not use "primary keys", I set up a replication column called "repindex".

Each site that adds records uses:

"siteID+sequencekey", this col, is col is only used fro replication, but I now have the situation that the primary key is allocated to this col.

As I'm now re-implementing in applications in java, I now want to allocate the primary key to another distinct column:

1. can i just drop the primary key then enable the key on another col
2. can the replication system still use the "repindex" col, without it being the primary key col

or do i have to
suspend replication
drop primary key constraint
enable new key col
regenerate replication support
re-enable replication.

I would ask tom, but getting a question to that guy is impossible these days.

steve Received on Sat Jan 01 2005 - 11:27:32 CET