I am trying to insert 22 records into a table from the migrated_rows table to fix a chaining problem. Each time I try to re-insert the records back into the table, I get the ORA-00947 error stating not enough values.

I have tried variations of the following queries:

insert into louise.produits select * from migrated_rows

insert into louise.produits
values
(select * from migrated_rows)

Any suggestions?