Jason,

The contents of RPL$_INDEX metadata (without all "insert into" statements,
just the first one) is:

"SET SQL DIALECT 3;

SET NAMES WIN1252;

CREATE DATABASE 'C:\AgendaDigital\Tabelas\Target\Tb_Clinica.gdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 1024
DEFAULT CHARACTER SET WIN1252;

INSERT INTO RPL$_IND (RPL$IND_NME, RPL$SRC_TBL_NME, RPL$SRC_KEY_CLS,
RPL$SRC_ADD_EXP, RPL$SRC_UPD_EXP, RPL$DST_TBL_NME, RPL$DST_TBL_CREATE,
RPL$DST_KEY_CLS, RPL$DST_DEL_EXP, RPL$STATUS, RPL$LOG, RPL$SRC_CLS,
RPL$DST_CLS)

VALUES ('I_ESPPROFI', 'TB_ESPECIALIDADE_PROFISSIONAL', 'ID_ESPEC_PROF',
NULL, NULL, 'TB_ESPECIALIDADE_PROFISSIONAL', 'F', 'ID_ESPEC_PROF', NULL,
'A', 'T', NULL, NULL);

VALUES ('IDX_AGENDA', 'TB_AGENDA', 'ID_ATENDIMENTO', NULL, NULL,
'TB_AGENDA', 'F', 'ID_ATENDIMENTO', NULL, 'A', 'T', NULL, NULL);

VALUES ('I_ESPCLINI', 'TB_ESPECIALIDADE_CLINICA',
'ID_ESPECIALIDADE_CLINICA', NULL, NULL, 'TB_ESPECIALIDADE_CLINICA', 'F',
'ID_ESPECIALIDADE_CLINICA', NULL, 'A', 'T', NULL, NULL);

VALUES ('I_EXPROFIS', 'TB_EXAME_PROFISSIONAL', 'ID_EXAME_PROF', NULL, NULL,
'TB_EXAME_PROFISSIONAL', 'F', 'ID_EXAME_PROF', NULL, 'A', 'T', NULL, NULL);

VALUES ('I_EXCONVEN', 'TB_EXAMES_CONVENIO', 'ID_EXAME_CONV', NULL, NULL,
'TB_EXAMES_CONVENIO', 'F', 'ID_EXAME_CONV', NULL, 'A', 'T', NULL, NULL);

VALUES ('I_EXCLINIC', 'TB_EXAME_CLINICA', 'ID_EXAME', NULL, NULL,
'TB_EXAME_CLINICA', 'F', 'ID_EXAME', NULL, 'A', 'T', NULL, NULL);


VALUES ('I_CONCLIEN', 'TB_CONVENIO_CLIENTE', 'ID_CONV_CLI', NULL, NULL,
'TB_CONVENIO_CLIENTE', 'F', 'ID_CONV_CLI', NULL, 'A', 'T', NULL, NULL);

VALUES ('I_CONPROFI', 'TB_CONVENIO_PROFISSIONAL', 'PK_ID_CONV_PROF', NULL,
NULL, 'TB_CONVENIO_PROFISSIONAL', 'F', 'PK_ID_CONV_PROF', NULL, 'A', 'T',
NULL, NULL);

VALUES ('IDX_PROFIS', 'TB_PROFISSIONAL', 'ID_PROFISSIONAL', NULL, NULL,
'TB_PROFISSIONAL', 'F', 'ID_PROFISSIONAL', NULL, 'A', 'T', NULL, NULL);

VALUES ('IDX_HORARI', 'TB_HORARIO_PROFISSIONAL', 'IDX_HORAPROF', NULL, NULL,
'TB_HORARIO_PROFISSIONAL', 'F', 'IDX_HORAPROF', NULL, 'A', 'T', NULL, NULL);

VALUES ('IDX_CONVEN', 'TB_CONVENIO', 'ID_CONVENIO', NULL, NULL,
'TB_CONVENIO', 'F', 'ID_CONVENIO', NULL, 'A', 'T', NULL, NULL);

VALUES ('IDX_CLIENT', 'TB_CLIENTE', 'ID_CLIENTE', NULL, NULL, 'TB_CLIENTE',
'F', 'ID_CLIENTE', NULL, 'A', 'T', NULL, NULL);

COMMIT WORK;
"

Is this that what you need?

Thanks for your repply

Ricardo Costa
Agenda Digital Ltda
Florianopolis - SC
ricardo@...

----- Original Message -----
From: "Jason Wharton" <jwharton@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, December 03, 2001 5:44 PM
Subject: Re: [IBO] Replication


> You may have had a error and now the status is preventing you from working
> with the replication index. I need to see the contents of the RPL$_INDEX
> table on your target database so that I can tell you how to hack it back.
> This is my way of forcing things to be correct and I hope to make it more
> friendly in the future.
>
> Did you hit an object in use error with this before?
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com