Originally posted by slimdave
what're the issues with rowid, Julian?
Sure!

In order to implement fast refreshes, all tables that form part of the replicated group, should have Primary keys defined.

Fast refreshes should be implemented as far as possible to reduce network traffic.

You should:

Use the rowid of rows and not the primary key;

Define primary keys for these tables;

Use complete refreshes.

Each of these has disadvantages:

§ Use rowid only for backward compatibility to Oracle 7 databases,
§ There is NO guarantee that the ROWID of a particular ROW will be the same from one day to the next. Oracle does not provide you that guarantee,
§ Move table will change rowid,
§ Export/import will change rowid,
§ If there are no unique columns for a specific table, then it will not be possible to define a primary key,
§ Complete refreshes are heavy on the network and should be avoided as far as possible.