Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: replication help -ora-23325

RE: replication help -ora-23325

From: <ramakrishna.gv_at_db.com>
Date: Mon, 18 Sep 2000 07:59:45 +0530
Message-Id: <10622.117219@fatcity.com>


Hi
  I think to handle the conflict resolution in site priority method

  1. u need to add a column to the table with varchar2(20).
  2. Generate replication support since u altered the table.
  3. Make column group
  4. Create a site priority group through dbms_repcat.define_site_priority.
  5. execute dbms_repcat.add_site_priority_site

  Try in this way.
  hope this will serve the purpose.
  Infact in this situation u donot need to use add_update_resolution procedure.

 Thanks & Regards



 Ram
 Tel:4236953

From: jbshaw_at_ingr.com on 15/09/2000 15:05 GMT

Please respond to ORACLE-L_at_fatcity.com

To: ORACLE-L_at_fatcity.com
cc:
Subject: RE: replication help -ora-23325

When I am trying to add it -
(had to type this in can't cut and paste out of the great java window
dbms_repcat.add_update_resolution(
sname => 'reptest',
oname => 'TEST',
column_group => 'primkey',
sequence_no => 1,
method => 'SITE PRIORITY',
priority_group => 'test_site_prioirty',
parameter_column_name =>'A');

.... . .-.. .--. .. ...- . -... . . -. .--. .-. --- -... . -.. John B. Shaw
Intergraph Public Safety
mailstop LR24A4
jbshaw_at_ingr.com
256-730-8038
All the usual disclaimers and some of the certifications

-----Original Message-----
Sent: Thursday, September 14, 2000 9:21 PM To: Multiple recipients of list ORACLE-L

Hi

   What point of time it is giving the error.      when u r trying to do ALTER_MASTER_REPOBJECT(for adding a site column in the table) or

                      MAKE_COLUMN_GROUP or DEFINE_SITE_PRIORITY.



 Thanks & Regards



 Ram
 Tel:4236953

Please respond to ORACLE-L_at_fatcity.com

To: ORACLE-L_at_fatcity.com
cc:

I'm trying to create a conflict resolution type of site priority - ( we have a master with updateable snapshots) I get a ora - 23325 - parameter type not varchar2.
I don't have a clue as to what parameter it is referring to and the wonderful documentation has failed to enlighten me - anybody have any suggestions as to what to look for.
oracle 8.1.6 on W2K
I.B. Stumped

.... . .-.. .--. .. ...- . -... . . -. .--. .-. --- -... . -.. John B. Shaw
Intergraph Public Safety
mailstop LR24A4
jbshaw_at_ingr.com
256-730-8038
All the usual disclaimers and some of the certifications

--
Author: Shaw, John B
  INET: jbshaw_at_ingr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Author: INET: ramakrishna.gv_at_db.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Author: Shaw, John B INET: jbshaw_at_ingr.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
Received on Sun Sep 17 2000 - 21:29:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US