469,299 Members | 2,035 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,299 developers. It's quick & easy.

replication and primary key

Hi,

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

Jul 19 '05 #1
3 5110
steve wrote:
Hi,

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).
"Nothing runs like a fox"
Still have an unlimited set here, for old times sake :)

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
What version Oracle?
The recommendation is to use primary keys for replication,
rowid is still supported for backward compatibility purposes.

(Advanced) Replication is pronounced dead by Oracle, BTW.
or do i have to
suspend replication
drop primary key constraint
enable new key col
regenerate replication support
re-enable replication.

You would, as soon as you change columns for replication
identification.

As it looks like a rebuild to start with, I'd look for
other options than Advanced Replication; 10g has other options,
which -in absence of version information- may or may not be
applicable to your situation.
If you want to stick to (Adv.) Replication, I'd rework your
design with primary keys.

--
Regards,
Frank van Bortel
Jul 19 '05 #2
On Sat, 1 Jan 2005 21:50:37 +0800, Frank van Bortel wrote
(in article <cr**********@news1.zwoll1.ov.home.nl>):
steve wrote:
Hi,

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).

"Nothing runs like a fox"
Still have an unlimited set here, for old times sake :)

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


What version Oracle?
The recommendation is to use primary keys for replication,
rowid is still supported for backward compatibility purposes.

(Advanced) Replication is pronounced dead by Oracle, BTW.

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

You would, as soon as you change columns for replication
identification.

As it looks like a rebuild to start with, I'd look for
other options than Advanced Replication; 10g has other options,
which -in absence of version information- may or may not be
applicable to your situation.
If you want to stick to (Adv.) Replication, I'd rework your
design with primary keys.


oracle is currently 9.0.2.6.
I also have a registered 10g, but have not upgraded to it yet.

You say replication is dead?, what options are available in 10g

steve


Jul 19 '05 #3
steve wrote:
On Sat, 1 Jan 2005 21:50:37 +0800, Frank van Bortel wrote
(in article <cr**********@news1.zwoll1.ov.home.nl>):

steve wrote:
Hi,

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).


"Nothing runs like a fox"
Still have an unlimited set here, for old times sake :)

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


What version Oracle?
The recommendation is to use primary keys for replication,
rowid is still supported for backward compatibility purposes.

(Advanced) Replication is pronounced dead by Oracle, BTW.
or do i have to
suspend replication
drop primary key constraint
enable new key col
regenerate replication support
re-enable replication.


You would, as soon as you change columns for replication
identification.

As it looks like a rebuild to start with, I'd look for
other options than Advanced Replication; 10g has other options,
which -in absence of version information- may or may not be
applicable to your situation.
If you want to stick to (Adv.) Replication, I'd rework your
design with primary keys.

oracle is currently 9.0.2.6.
I also have a registered 10g, but have not upgraded to it yet.

You say replication is dead?, what options are available in 10g

steve


Streams
DataGuard

--
Daniel A. Morgan
University of Washington
da******@x.washington.edu
(replace 'x' with 'u' to respond)
----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Boris Villazon | last post: by
2 posts views Thread by Ian Wyld | last post: by
12 posts views Thread by debian mojo | last post: by
4 posts views Thread by SQLNow | last post: by
3 posts views Thread by subaruwrx88011 | last post: by
1 post views Thread by tropicana | last post: by
3 posts views Thread by steve | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Geralt96 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.