Database Error Messages

Release
toggle
  • 23ai
Updated
Jun 24, 2024

CPY-00004

Source and destination table column names don't match

Cause

On an APPEND operation or an INSERT (when the table exists), at least one column name in the destination table does not match the corresponding column name in the optional column name list or in the SELECT command.


Action

Re-specify the COPY command, making sure that the column names and their respective order in the destination table match the column names and column order in the optional column list or in the SELECT command