INSERT INTO TABLE that has mismatched structure.
From: Kevin <factor_at_mail.ru>
Date: 29 May 2002 20:59:55 -0700
Message-ID: <eb7b37e9.0205291959.78779f1e_at_posting.google.com>
Date: 29 May 2002 20:59:55 -0700
Message-ID: <eb7b37e9.0205291959.78779f1e_at_posting.google.com>
Hello!
I want to append records from one table to another, that contain more
fields.
I try to make this:
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.
Kevin.
INSERT INTO K_PR_ARX SELECT * FROM k_pr1000;
Please help me.