Hi,
We had by mistake dropped the referencial integrety between two huge tables
and now I'm facing the following messages when trying to recreate the
foreign key again:
alter table posicoes_controles add
CONSTRAINT protocolo FOREIGN KEY (protocolo)
REFERENCES posicoes (protocolo) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE CASCADE;
ERROR: insert or update on table "posicoes_controles" violates foreign key
constraint "protocolo"
DETAIL: Key (protocolo)=(338525035) is not present in table "posicoes".
********** Erro **********
ERROR: insert or update on table "posicoes_controles" violates foreign key
constraint "protocolo"
SQL state: 23503
Detalhe: Key (protocolo)=(338525035) is not present in table "posicoes".
As the error message tells, the table "posicoes_controles" has values in
column "protocolo" that are not present in column "protocolo" of table
"posicoes". This happened because some programs removed rows from table
"posicoes" while the referencial integrity was dropped.
Now I need to remove all rows from table "posicoes_controles" that has not
corresponding row in table "posicoes".
As these are huge tables, almost 100GB each, and the server
hardware restricted (4GB RAM) I would like a suggestion of which command
or commands should be used from the performance perspective.
Column "protocolo" is "posicoes" table primary key but is not in any index
colum of table "posicoes_controles".
Thank you very much for any help!
--
Reimer
47-3347-1724 47-9183-0547 msn: carlos.rei...@opendb.com.br
