CPY0002:
Illegal or missing APPEND, CREATE, INSERT, or REPLACE option
Cause:
An internal COPY function has invoked COPY with a create option (flag) value that is out of range.
Action:
Please contact your Oracle Customer Support representative.
CPY0003:
Internal Error: logical host number out of range
Cause:
An internal COPY function has been invoked with a logical host number value that is out of range.
Action:
Please contact your Oracle Customer Support representative.
CPY0004:
Source and destination table and 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:
Respecify 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.
CPY0005:
Source and destination column attributes don't match
Cause:
On an APPEND operation or an INSERT (when the table exists), at least one column in the destination table does not have the same datatype as the corresponding column in the SELECT command.
Action:
Respecify the COPY command, making sure that the datatypes for items being selected agree with the destination. You can use TO_DATE, TO_CHAR, and TO_NUMBER to make conversions.
CPY0006:
Select list has more columns than destination table
Cause:
On an APPEND operation or an INSERT (when the table exists), the number of columns in the SELECT command is greater than the number of columns in the destination table.
Action:
Respecify the COPY command, making sure that the number of columns being selected agrees with the number in the destination table.
CPY0007:
Select list has fewer columns than destination table
Cause:
On an APPEND operation or INSERT (when the table exists), the number of columns in the SELECT command is less than the number of columns in the destination table.
Action:
Respecify the COPY command, making sure that the number of columns being selected agrees with the number in the destination table.
CPY0008:
More column list names than columns in the destination table
Cause:
On an APPEND operation or an INSERT (when the table exists), the number of columns in the column name list is greater than the number of columns in the destination table.
Action:
Respecify the COPY command, making sure that the number of columns in the column list agrees with the number in the destination table.
CPY0009:
Fewer column list names than columns in the destination table
Cause:
On an APPEND operation or an INSERT (when the table exists), the number of columns in the column name list is less than the number of columns in the destination table.
Action:
Respecify the COPY command, making sure that the number of columns in the column list agrees with the number in the destination table.