unable to insert

[ncsmith]

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?

[anthony_t]

Do a describe on both of the tables to ensure that they have EXACTLY the same structure. If they do not then you cannot use that method to insert into PRODUIT.

If the columns in the table are in different order or there are a different number of columns in each table then you have to explicitly select them.

i.e. PRODUITS ( col_a number(5), col_b varchar2(30) )
    MIGRATED_ROWS( col_b varchar2(30), col_a number(5), col_c DATE )
In this case you must do the following:
     insert into PRODUITS( col_a, col_b )
     select col_a, col_b from MIGRATED_ROWS;

I hope that this helps...