INSERT INTO TABLE that has mismatched structure.

Hello!  

 I want to append records from one table to another, that contain more  fields.  

 I try to make this:
 INSERT INTO K_PR_ARX SELECT * FROM k_pr1000;  

 and get this message: ORA-00947 not enough values.  This happened because the table k_pr1000 has got less fields than the  table K_PR_ARX. I think exist other way to make this thing (may be  hints, etc).  

 Excuse me for my bad english.
 Please help me.  

 Kevin.
 Russia. Received on Wed Jun 05 2002 - 02:19:43 CEST