Re: replication and primary key
From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sat, 08 Jan 2005 19:35:52 -0800
Message-ID: <41e0a56b_1_at_127.0.0.1>
>>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.
>>
>>
Date: Sat, 08 Jan 2005 19:35:52 -0800
Message-ID: <41e0a56b_1_at_127.0.0.1>
steve wrote:
> On Sat, 1 Jan 2005 21:50:37 +0800, Frank van Bortel wrote > (in article <cr69q3$u0t$1_at_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 damorgan_at_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 =---Received on Sun Jan 09 2005 - 04:35:52 CET