Ora-01410: Invalid Rowid

[yxez]

thanks davey
sad :( ... this table dont have PK and its partitioned one and got 100+million rows.

Is this the right wat to do the primary key?:

alter table loans_a add(pk_1 number);
alter table loans_b add(pk_2 number);

update loans_a set pk_1=rownum;
update loans_b set pk_2=rownum;

alter table loans_a add primary key (pk_1);
alter table loans_b add primary key (pk_2);

Thanks