DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2001


    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
    (select * from migrated_rows)

    Any suggestions?

  2. #2
    Join Date
    Sep 2001
    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...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.