Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00947: Not enough values

806245Nov 3 2010 — edited Nov 3 2010

I am trying to append Table A into Table B, where Table A has fewer columns than Table B. Is this no way that this operation can be carried out? Can't data insertion just take place between mathching columns, leaving additional columns in the target unfilled?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 1 2010

Added on Nov 3 2010

#general-database-discussions

5 comments

11,474 views